Tabbed subform question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top