How do I change record source on a Form via Combobox? VBA
What I have now:
The user chooses Form1 from Combobox, Form1 opens with record source
to Table1
The user chooses Form2 from Combobox, Form2 opens with record source
to Table2
Form1, Form2, FormX are identical, the only thing that changes is record
source eg. TableA
What I am trying to accomplish is:
The user chooses A from Combobox then FormX opens and based on what
user has chosen it changes the record source eg. to the Table A. This way I don't have to have a form A, B, C...
What I have now:
The user chooses Form1 from Combobox, Form1 opens with record source
to Table1
The user chooses Form2 from Combobox, Form2 opens with record source
to Table2
Form1, Form2, FormX are identical, the only thing that changes is record
source eg. TableA
What I am trying to accomplish is:
The user chooses A from Combobox then FormX opens and based on what
user has chosen it changes the record source eg. to the Table A. This way I don't have to have a form A, B, C...