Subform query results

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.
 
G

Guest

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top