You can't parametrise the table name - you will need to concatenate the name into your SQL statement. Note also that more often than not requiring the user to select a destination table is the sign of a problem with the design.
I'm trying to add parts to a quote, but once in the quote I can change the wording without it affecting the original data. The parts often go under different heading within the quote. I'm allowing the combo box to choose which table / heading the data will go to. People who use the database then have a choice.
Decided to ditch the relational bit and use a unbound text box as reference to the quote I'm viewing. It seems to work well, and I'm not getting tied up with relationships etc...
it's a quotation database. Each table will hold parts depending on the Sub title of the quotation. Eg I'll put some parts under the Hardware heading so that will go into the tblHardware, others will go under Extras heading so again that will go into the tblExtras and so on. Each part picks up the Quote number and when the user is finish it pulls everything together to produced a nice report with parts under their correct heading. well that's the idea.
The user would like the option of putting parts in any of the headings depending on who the quote is going out to. hence using the combo box to direct the append query.
The other good thing is once the data has been added to the relevant tables I can modify the price and wording of some of the items without affect the master product list. hope that makes sense? thanks again for your help
P.S Any recommendations of a decent book to help me understand access VBA? cheers