Combo Box Search By Query

  • Thread starter Thread starter dan.cawthorne
  • Start date Start date
D

dan.cawthorne

Hi All,

Ive Created a Dialog Box With some tick box's and a Combo Box.

the Dialog box aint quite working the way i would like it to.

the dialog box will open a report which the report has a record source
of the query.

the tick box on is ment to Included Projects that have Maintenance
assigned. but the tick box is set to a yes or no. and the query looks
at this field

the combo box is the same, the combo lists all the end clients, and it
works if i select a client which is assigned to the project, in which
case i could return 100 Starbucks Coffee.

but lets say i just want to display all projects that have maintenance
and leave the combo box blank, But it returns Zero Projects.

How do i get round this problem?
 
If you post the query here , you would probably get more responses.

You most likely need to add an IS NULL parameter into the WHERE clause of
your query such as:

'doesn't return all records when LASTNAME on dialog form is blank
WHERE (((tblStudents.LName)=[forms]![frmCallReportOptions]![LASTNAME]));

'does return all records when LName on form is blank
WHERE (((tblStudents.LName)=[forms]![frmCallReportOptions]![LASTNAME])OR(
[forms]![frmCallReportOptions]![LASTNAME] is Null));
 
Back
Top