I think I am having a mental block here,
I have a select query based on 1 table, and want to filter the data from 2 combo boxes on a form..
so good so far, pretty standard stuff, however both of the combo boxes will always have a value but the column in the table may not (it will be null), what I am after is after the user has selected a value in the combo box if there is no match - show all records, if there is a match show only matching records
I am using Forms!form!combobox as the parameters in the query
Does that make sense?
I have a select query based on 1 table, and want to filter the data from 2 combo boxes on a form..
so good so far, pretty standard stuff, however both of the combo boxes will always have a value but the column in the table may not (it will be null), what I am after is after the user has selected a value in the combo box if there is no match - show all records, if there is a match show only matching records
I am using Forms!form!combobox as the parameters in the query
Does that make sense?