Select table for append query

[luceze]

I have a database that copies a table before a delete query runs. What I would like to do is be able to reload using an append query to repopulate the table that was deleted. The problem that I am having is that the user needs to be able to choose which backup table to reload.

For example:
I have a list box that lists all the back up tables. The user then selects which backup to load. I can grab the table name but how do I specify in the query which table get the data from.

Any idea is appreciated.

 

[Rick39]

Something like:

"INSERT INTO [YourTable]
SELECT YourSourceTable.*
FROM '" & Me!MyListBox & "';"