Tabbed subform question

[Guest]

I have created a form based on a query that selects all entries of a single
day. The maximum entires is 6 so there would only be 6 rows returned max for
a single day. What I have been able to do is do a summary section of the day
and that all works just fine in listing out all the employees and the total
sales and expenses incurred for the day. Now what I would like to do is
create a tabbed subform with 6 tabs and have tab "Reg #1" display the first
employee sales information, tab "Reg #2" display the second employees sales
information and so on and so forth. Is there a way to have each tab display
the records? Right now each tab shows only the first record returned by the
query. Any help or direction would be appreciated.

 

[tina]

you're getting records for all the employees (or registers, whatever) from a
single query, correct? you can bind the query to the form's RecordSource,
and arrange the form controls directly in the Detail section of the form
(*not* on a tab page). then add the tab control *on top of* the other
controls - they'll "show through" on every tab page. label each of the six
tabs as Reg#1, Reg#2, etc (or whatever). in the tab control's Change event
procedure, add code to filter the form's RecordSource to return only the
record the corresponds to the tab page selected.

hth