Subform query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with multiple combo boxes with a subform that displays the
results of a query based on the combo boxes. I am using a button to requery
the subform.

The query is using Is Null events for each combo box so if a combo box is
left empty all results for that box are returned and query will filter by the
remaining boxes.

Here's the problem, if I leave the 1st box empty, the subform does not
return any results. The weird thing is if I run the sub form by itself and I
leave the 1st box empty and it works correctly. What am I doing wrong.

I'm kind of new to Access so please bear with me. If you need to see my
code, please let me know.
 
I found the problem!!!
In the Subform/Subreport box properties under the Data tab I removed the
entries under Link Child Fields and Link Master Fields and now I see all my
results!!
 
Back
Top