• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

MS Access Form switiching several tables

I'm looking for some guidence/suggestions on this one.

I have 3 tables each in the exact same layout (don't ask why they are not in a single table)
I want to create a form that has 3 radio buttons - each representing one of the 3 tables.

I want to display a data grid of the associated table when the related button is selected.  Basically allowing me to jump back and forth between the two tables.
0
keschuster
Asked:
keschuster
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can do that by changing the recordSource of the form

select case frame0
       case 1
            me.recordsource="table1"
       case 2
            me.recordsource="table2"
       case 3
            me.recordsource="table3"

end select
0
 
Rey Obrero (Capricorn1)Commented:
or create a form with a datasheet subform and just change the recordsource like this

       me.subformControlName.form.recordSource="table1"

etc
0
 
keschusterAuthor Commented:
I'm with you.  The grid is actually a subform.  How do I reference that subform to change the recordsource?
0
 
Rey Obrero (Capricorn1)Commented:
select case frame0
       case 1
            me.subformControlName.form.recordSource="table1"
       case 2
            me.subformControlName.form.recordSource="table2"
       case 3
            me.subformControlName.form.recordSource="table3"

end select
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now