combo box query

[ElSteveO]

I have made a form w/a text box for Store Name and a second one for date. When I press the command button it runs a select query and opens a report based on my input. When I substitue the text box for Store Name w/a combo box (and use the builder to add the combo box into the query) the query runs but produces a blank report, meaning the query is not receiving my input from my combo box. When I run the query w/o using the form it works fine. How do I fix this?

 

[Digsy]

Showing some code would be a good start as most of us aren't clever enough to read minds.

I suggest you show the snippet of code where you are trying to add the input from your combo box.

Dave

 

[ElSteveO]

I didn't use any code, I used the wizard to create the combo box and grab the info from a table called "stores". My query finds the combo box choice as it would if it were a text box, but it doesn't work, leading me to believe that I probably need some code.

Don't be gettin' up into my grill. If you want to help I would be greatful.
Steve

 

[sdraper]

Is this in MSAccess? If so you might wanna try the Access Forum...

Sam