How do I change record source on a Form via Combobox? VBA or?
What I have now:
1. 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 and Form2 are identical, the only thing that changes is record source

What I am trying to accomplish is:
2. 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 dont have to have a form A, B, C...