I need to develop a Tab Form where selecting a particular key from an
unbound combo listbox will resulting in the display one or many
records from several tables, where each tab has the matching rows for
the selected key.
There does not appear to be a similar example in the Northwind
database. The objective is to show related records from several
tables which have a common partial key. It seems that I cannot use a
single query as the basis for all pages of the tab, as this seems to
preclude displaying a datasheet of one or more records for any of the
underlying tables. I have experimented with using an Apply Filter
macro but this seems to only effect the overall form's underlying
query. It seems like each page of the tab form needs its own
underlying query to populate a datasheet specific to the table upon
which that tab is based. I need to be able to change the selection
key and then cause the datasheets for all the tabs to requery to match
the new key selected.
Eg:
Key 1234567 (selected from a list of valid keys based on a query)
Tab Page 1
Key 123456 - Table 1 Row 131 data
Key 123456 - Table 1 Row 293 data
Tab Page 2
Key 123456 - Table 2 Row 55 data
Tab Page 3
No records matching
Tab Page 4
Key 123456 - Table 3 Row 24