louis
01-24-2002, 06:22 PM
I have created a form with unbound text box as criteria for a query. In the criteria section of query i have written:
[Forms]![FORM NAME]![UNBOUND TEXT BOX NAME]
When i run the form i type in the text that i want the query to be based upon. This works fine. I have re-created this same scenario but instead i used an unbound combo box with my customer names. I would like to run a query by my customer names. I keep getting a blank report. It is identical to the example above in every way except that i do not have to type the information i just choose it from the list. I'm confused, Please Help.
[Forms]![FORM NAME]![UNBOUND TEXT BOX NAME]
When i run the form i type in the text that i want the query to be based upon. This works fine. I have re-created this same scenario but instead i used an unbound combo box with my customer names. I would like to run a query by my customer names. I keep getting a blank report. It is identical to the example above in every way except that i do not have to type the information i just choose it from the list. I'm confused, Please Help.