Thank you so much for all your help...It Works great!!! I am new to this online forum...I have used forums to search for answers before but never to post a question so I apologize for not giving better information in my question...I didn't supply my code as I work in HR and I am prohibited to do so and I do have business reasons for the temporary tables and the need for them.....sorry. :*(
But thank you all the solution works just...
Teresa Kline
Last Activity: Mar 28 '12, 06:01 PM
Joined: Mar 27 '12
Location:
-
I'm sorry that I didn't give enough information in my original post...I have a process that runs and selects a group of people based on their location from SAP. The selection is then written to a table in SAP that is named for example: tbllocation1033 02012. Then a second query is run for a different location and that table is named...tblloca tion203302012.. and so on. At this point various users will need to go into the database and update their specific...Leave a comment:
-
Yes my question was how do I do this either in VBA or in the form?
Thanks,
TeresaLeave a comment:
-
Changing record source based on combo box
I have a form with a combo box. In the combo box is a list of tables in my database. I want to be able to select a table from my combo box and based on that selection open another form that uses that table as a record source.
I want to use the same form each time but change the record source based on the table I select from my combo box.
Thanks for any help.
Teresa
No activity results to display
Leave a comment: