By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,583 Members | 617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,583 IT Pros & Developers. It's quick & easy.

Tab Forms with Multiple Rows

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Not sure what you are trying to accomplish. Do you want one record per tab
page? It's trivially easy to place a Subform Control on a tab page and
display continuous forms view (which, of course, can show many records). I
can think of some scenarios for using that to display details of a
particular record on another page of the tab control.

As far as I know, there is no support for a tab page for each record -- that
would seem to be useful to me only for a small number of records or it would
overwhelm the user.

My applications just don't use datasheet view. I use it myself when I am
doing "end user" kind of things, but that wouldn't include embedding it in a
Subform Control on a tab page.

Larry Linson
Microsoft Access MVP

"Greg Neef" <ne***@linuxmail.org> wrote in message
news:25************************@posting.google.com ...
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

Nov 13 '05 #2

P: n/a
Definitely don't want a tab per record, rather a tab per table where
multiple tables share related data in such a mannor that there may be
zero to many rows on each table related to the particular "key". I'll
try the continuous forms approach but still am unclear how to filter
or select data from all of the tables so that only the appropriate
rows from each are displayed on each tab, in the continous form. I
can't just join all of them together in a single query without getting
unspecified outer join problems. A filter macro only effects the
underlying table or query for the overall form, and has no effect on
data in each tab independently.

Essentially I need to do a separate select for each table using the
same selection criteria for each and displaying the results for each
table in tab.

My specific application has real property tax info. I have a table
for Single Family Homes, One for Mobile Homes, One for Commercial
Property... all of which share the Parcel Identification Number (PIN)
but which have uncommon attributes (thus the need for separate
tables). I particular parcel may may zero or many single family homes
AND zero or many mobile homes AND zero or many commercial buildings.
I would like to display ALL of the buildings for a particular PIN in a
tab form with one tab for each type of building.
Nov 13 '05 #3

P: n/a
Imbed a continuous forms view Form for each table in a Subform Control on
the tab pages. Use the LinkMasteFields and LinkChildFields properties of the
Subform controls to synchronize them with particular records on the main
form.

Larry Linson
Microsoft Access MVP

"Greg Neef" <ne***@linuxmail.org> wrote in message
news:25**************************@posting.google.c om...
Definitely don't want a tab per record, rather a tab per table where
multiple tables share related data in such a mannor that there may be
zero to many rows on each table related to the particular "key". I'll
try the continuous forms approach but still am unclear how to filter
or select data from all of the tables so that only the appropriate
rows from each are displayed on each tab, in the continous form. I
can't just join all of them together in a single query without getting
unspecified outer join problems. A filter macro only effects the
underlying table or query for the overall form, and has no effect on
data in each tab independently.

Essentially I need to do a separate select for each table using the
same selection criteria for each and displaying the results for each
table in tab.

My specific application has real property tax info. I have a table
for Single Family Homes, One for Mobile Homes, One for Commercial
Property... all of which share the Parcel Identification Number (PIN)
but which have uncommon attributes (thus the need for separate
tables). I particular parcel may may zero or many single family homes
AND zero or many mobile homes AND zero or many commercial buildings.
I would like to display ALL of the buildings for a particular PIN in a
tab form with one tab for each type of building.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.