Multi-record tabbed subform question

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

Guest

I have seen alot of posts in regards to this question and I am not
understanding how to fix the problem I am having. I have a main form that
returns anywhere from 1 to 6 rows of information based on a date. I have
created a tabbed subform. The tabbed subform has 6 tabs, one for each
possible row that could be returned from the main forms query. When I look
at the information on the tabs every tab has the first record returned by the
query. What I need is to have tab 1 match record 1, tab 2 match record 2,
tab 3 match record 3 etc etc. How do I get the tabs to change information
and not keep showing only the first record?
 
Hello Ron.

Ron P said:
I have seen alot of posts in regards to this question and I am not
understanding how to fix the problem I am having. I have a main
form that returns anywhere from 1 to 6 rows of information based
on a date. I have created a tabbed subform. The tabbed subform has
6 tabs, one for each possible row that could be returned from the
main forms query. When I look at the information on the tabs every
tab has the first record returned by the query. What I need is to
have tab 1 match record 1, tab 2 match record 2, tab 3 match record
3 etc etc. How do I get the tabs to change information and not
keep showing only the first record?
Click to expand...

If you have one subform, there will be only one current record in it.
I think that you don't need a tabbed subform but a tab control with
6 subforms. Maybe you can link the subforms to the main form by
linking a special field that identifies each sub-record with a
textbox in the main form (that my be calculated).
 
Back
Top