JustJerry
09-08-2005, 10:20 PM
I have created several queries in a project I am working on, but I am now trying to create one specifying certain criteria...something I have not done before yet.
I have a subform that this query is to be used for, and subform is called "LineSub". LineSub's data source is also built on a query called "LineQry".
On this subform, I have a combobox that the user selects a certain product, and after choosing a product, a control named "WCMan" is automatically filled in with the manufacturer.
I have a second combobox that I am trying to use a query to list ONLY matching products based on the manufacturer listed in the control "WCMan"
I have tried using=Me.WCMan in the 'criteria' portion of the second query I am working on, but when I open up the forms, I get a message box asking for the value of Me.WCMan. If I fill in the message box, the combobox does list what I am looking for.
Can someone clue me in on how to have the query work correctly, and how to type criteria based on other values in a from?
Thank you
Jerry
I have a subform that this query is to be used for, and subform is called "LineSub". LineSub's data source is also built on a query called "LineQry".
On this subform, I have a combobox that the user selects a certain product, and after choosing a product, a control named "WCMan" is automatically filled in with the manufacturer.
I have a second combobox that I am trying to use a query to list ONLY matching products based on the manufacturer listed in the control "WCMan"
I have tried using=Me.WCMan in the 'criteria' portion of the second query I am working on, but when I open up the forms, I get a message box asking for the value of Me.WCMan. If I fill in the message box, the combobox does list what I am looking for.
Can someone clue me in on how to have the query work correctly, and how to type criteria based on other values in a from?
Thank you
Jerry