I've done this before, but for some reason it is completely escaping me. I'm using Access 2000.
I have a form with a combo box.
I have a subform on the same page.
I have one query, and a table with a bunch of data.
Thats it.
I should be able to have the user pick from the values available in the combo box so that the value the user picks gets thrown into my query and then back onto the page as a subreport.
However the combo box and the query don't seem to be on speaking terms since the subform does not display the queried data.
If i just run the query, it works fine.
If i put "=somecriteria" into the query it shows up on the subform. So i put =[Forms]![myform]![mycombobox] into the criteria category in the query, and this is where everything halts.
In the future, I'd like to add a text box to the form to search another field, so I do want to use the LinkMasterField because it will prohibit the use of the secong search. Thanks to anyone with the patience to sit through my descrition of this problem...