Help with getting MS Query Parameters from a combo box....

[kimcheebowl]

howdy,

I'm new to the forum. I just ran a search regarding my issue but came up with nothing.

Here is my scenario...

I have 2 worksheets... one titled Invoices and the other CustomerNumber.

The CustomerNumber sheet has a query that just pulls CustomerNumbers from our SQL database.

The Invoice sheet also uses a query that pulls other bits of data based on a "criteria/parameter" which happens to be CustomerNumber. On this sheet (Invoices) there is a combobox that I've named under the properties window as custnocombo which I've then defined a label as custbox.

The combo box pulls the customernumbers from the CustomerNumber sheet successfully.

What I'm trying to do is in the query on the Invoices sheet... I'm polling the data from the combobox into the criteria/parameter of my query.

According to my books and google searches... the correct syntax is

[Forms]![FormName]![ComboBoxName]

so in my case.. I have

[Forms]![Invoice]![custnocombo]

My worksheet is named Invoice and my combo box is named custnocombo. I've also tried replacing custnocombo with custbox (which is the label name that I've defined) and when I try to run the query... Excel spits back a "Syntax Error in Parameter" error with no further explanations.

Am I naming my forms or combo box wrong? any help is appreciated at this point. Thanks!

-Confused... and more confused
Jin Kim