Hey all.
I have a form that I use to select records based upon fields in that form. For example, on my form I have the following fields - Manager, Work Area, Result etc.
The user can enter a value in either of these fields via a combo box. When they click a command button, a new form is opened displaying the records that match the critera based upon their filter selections. So they should be able to select either, or all of these fields.
My problem is that all fields need to have a value entered, or the query returns a blank screen.
How can I use the criteria field of the query to either select the enrty made on the form ((Forms)!(frmdatabasesearch)!(cboworkarea)), or if the field is null, then select all records?
Thanks in advance.
Kev.
Never trust the French.
How can you trust a country that has 256 different types of cheese.
- Spike Milligan.
I have a form that I use to select records based upon fields in that form. For example, on my form I have the following fields - Manager, Work Area, Result etc.
The user can enter a value in either of these fields via a combo box. When they click a command button, a new form is opened displaying the records that match the critera based upon their filter selections. So they should be able to select either, or all of these fields.
My problem is that all fields need to have a value entered, or the query returns a blank screen.
How can I use the criteria field of the query to either select the enrty made on the form ((Forms)!(frmdatabasesearch)!(cboworkarea)), or if the field is null, then select all records?
Thanks in advance.
Kev.
Never trust the French.
How can you trust a country that has 256 different types of cheese.
- Spike Milligan.
