G
George
I'm writing an application for the security desk of a
large apartment complex.
Tables include apartment, residents, permanent access, and
vehicles. All tables are linked using the apartmentID.
I have a View Only form that will look up the apartment
information and have a tab control with a tab for
residents, a tab for permanent access, and a tab for
vehicles.
I have one query based subform on each tab which should
display the information for the selected main form's
apartment.
This worked great until I started adding the subforms to
the tabs. First subform worked great. Second subform
worked great. When I added the third subform, it doesn't
work at all and the first two subforms now pull up ALL of
the records in the referenced table instead of just the
linked records.
Is there a limit to the number of subforms you can have on
a form (4 didn't seem like too many)? Could this be a
timing issue because it seems like the queries on which
the subforms are based are suddenly not getting the
ApartmentID?
large apartment complex.
Tables include apartment, residents, permanent access, and
vehicles. All tables are linked using the apartmentID.
I have a View Only form that will look up the apartment
information and have a tab control with a tab for
residents, a tab for permanent access, and a tab for
vehicles.
I have one query based subform on each tab which should
display the information for the selected main form's
apartment.
This worked great until I started adding the subforms to
the tabs. First subform worked great. Second subform
worked great. When I added the third subform, it doesn't
work at all and the first two subforms now pull up ALL of
the records in the referenced table instead of just the
linked records.
Is there a limit to the number of subforms you can have on
a form (4 didn't seem like too many)? Could this be a
timing issue because it seems like the queries on which
the subforms are based are suddenly not getting the
ApartmentID?