If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering Multiple Tabs
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? |
#2
|
|||
|
|||
Filtering Multiple Tabs
Access Fried wrote:
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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Filtering Multiple Tabs
"Rick Brandt" wrote: Access Fried wrote: 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. -- 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? |
#4
|
|||
|
|||
Filtering Multiple Tabs
Access Fried wrote:
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? 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|