Hi all,
This question is fairly simple (hopefully). I'm trying to create a form that can interact with several different tables (all of which have the same fields). I'm using this to keep track of training for volunteers. I have an idea of how to write a code to input several fields into one specified table. Can I swap out the 'target' for a combo box code? That way I can select a specified table from a combo box (rather than having the one table written into the code), hit a button, and the fields would populate in that specified table. Let's say the table's names are master_log and training_log. The code of the master_log would be:
DoCmd.RunSQL "INSERT INTO master_log VALUES ([combo0].value)"
How would I switch out the master_log with the combo box, so I could select master_log or training_log from drop down box?
Thanks!