Filtering Multiple Tabs

[Access Fried]

I have two tables, both have one similar field. I have created a form for
both, then created another form with tabs and inserted the two original forms
onto sub-forms (one on each page), so I can flip between the two forms. I
want to filter by form the field that is similar and it to bring up the
records in both tabs for that filter. Any ideas?

 

[Rick Brandt]

I have two tables, both have one similar field. I have created a
form for both, then created another form with tabs and inserted the
two original forms onto sub-forms (one on each page), so I can flip
between the two forms. I want to filter by form the field that is
similar and it to bring up the records in both tabs for that filter.
Any ideas?

Get rid of one subform and use the parent form for that table. You can
still place those controls for the parent form onto one of the TabPages.
That way you have a parent form with a subform which is easier to link since
that is how subforms are set up to work. Linking two subforms is possible,
but makes it more complicated than it needs to be.

 

[Access Fried]

Get rid of one subform and use the parent form for that table. You can
still place those controls for the parent form onto one of the TabPages.
That way you have a parent form with a subform which is easier to link since
that is how subforms are set up to work. Linking two subforms is possible,
but makes it more complicated than it needs to be.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Thanks Rick, that worked a treat. Problem is the parent form takes up the whole page and the sub-form takes up a whole other page. When I add the subform to the bottom of the parent form, I added a page break, but the user has to scroll down to get to the subform when I'd rather make it easier and they tab across instead. Am I able to do this? Or is there an easier way?

 

[Rick Brandt]

I don't understand. Are you using a TabControl or not? I thought you were
going to have the main form controls on one TabPage and the subform on a second
TabPage. That should result in a form that requires no scrolling.