wide search query

  • Thread starter Thread starter Dr. Selima
  • Start date Start date
D

Dr. Selima

Dear All, I have a data base for the operative room containing more than
1000 records, I need to make a form with multiple unbound fields each in the
form of a combo box, so if I want to select operations performed by a
certain Surgeon I can select them, and in the same time if i need to have a
certain type of operation performed by a certain Doctor i can get them, I
made this based on query, but I have a problem that if i select one doctor
without selecting the operation no records are got, is there a way out,
Some thing like wide search, with more limiting ones
 
Doc,

I suspect the criteria in your query are something like:
Forms!FormName!cboOperation
right? Well, just change this to:
Like Forms!FormName!cboOperation & "*"
That way if the cboOperation is left blank (Null value) you will get all
records in your results, otherwise you will get those matching the selected
operation type. The same, of course, goes for Doctors, in case you want to
search by operation type regardless of doctor name.

HTH,
Nikos
 
Back
Top