Forms and queries question

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hello:

I have a form that has several subforms. Each of the
subforms use the same query, but are set to display
different information. When I print the form with the
subforms, I get a message something like "can't open any
more tables". Should I set each subform to open with its
own query?

Thanks
 
Just as a practical matter, it is always best to use a separate query for
each form... limiting the fields retrieved to just those needed for the
purpose. I haven't experienced the problem you describe, but that would be
the first thing I'd try.

If that doesn't do the trick, follow up here, and clarify whether the
different information means you are using different LinkMasterFields and
LinkChildFields for each Subform Control, or if that just means you're
displaying different fields from the table in each Subform.

Larry Linson
Microsoft Access MVP
 
Thanks Larry! I have a feeling that your suggestion will
work. The query uses several tables and I haven't
limited the fields retrieved to just those needed. The
Subform Controls display the same fields, but I'm trying
to allow the user to view information for different
dates -- as with a calendar.
 
Back
Top