Another Combo Box Problem!

[AndyD]

Im a bit of a newbie, so please be kind...

Have created a form with 2 Combo boxes (Member & Surname) which are linked to my table. Have also created an OK button to call up a Query with the values selected. The Combo boxes seem to work OK (correct info) I have made sure that the criteria section is "linked" to the correct combo box values but still blank. If I select nothing in the boxes the query displays all fields OK which I presume is right. Also, if I run the query directly and enter values all is fine so presume the problem is the passing of the value from the form to query?

Any help would be gratfully received as I've spent far too long playing with this!

Andy

 

[lgw002]

Think you need to show your code or explain a bit further,

however as a complete guess make sure that the combo boxes are not selecting multiple columns. ( Look in your rowsource paramater for very roughly SELECT table.tableID,table.tabledata FROM table ). It then may possably be be that you are viewing in the combo one of the columms ( in this case tabledata ) but passing to your query a different column ( again in this case tableID ). This would corrospond to your results of no_choice = all records, but any_ choice = no records as no match available

The above problem with cascading comboboxes made my head hurt till I got it straight

Al