Multi-record tabbed subform question

[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?

 

[Wolfgang Kais]

Hello Ron.

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?

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).