Hi
I am using a tab form - i have placed a floating sub-form which display continous records from a table. The table has a field which identifies a record of being one of 4 types (wah, wrh, weh, wch)
Ideally - i want a user-friendly tab system (a tab form per type (i.e. wah) - so when then user selects a tab the sub-form only displays the records related to the type.
the tab name is the same for the type/group.
Im after a step-by-step guide if any one can help - iv got the tabs sorted and the form set-up. I just need to autmate this process in vba.
do i:
- use vba to run a new sql row source - how?
- how do i refer to subform source / tabs etc
- use a filter in vba of somesort - how?
Any help will be much appreciated...!!
I am using a tab form - i have placed a floating sub-form which display continous records from a table. The table has a field which identifies a record of being one of 4 types (wah, wrh, weh, wch)
Ideally - i want a user-friendly tab system (a tab form per type (i.e. wah) - so when then user selects a tab the sub-form only displays the records related to the type.
the tab name is the same for the type/group.
Im after a step-by-step guide if any one can help - iv got the tabs sorted and the form set-up. I just need to autmate this process in vba.
do i:
- use vba to run a new sql row source - how?
- how do i refer to subform source / tabs etc
- use a filter in vba of somesort - how?
Any help will be much appreciated...!!
