Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append a record from a user specified table in Access to another table

Status
Not open for further replies.

cheryl27284

Technical User
Jan 31, 2003
28
0
0
US
I have 15 tables that are exact replicas of each other. ON a form I have 15 queries that represent the 15 tables. I have little time so I can not recreate the database right now. The user needs to be able to move a record from one table to another on the form. The user may choose any record from any table and move the record to any table. I know how to do an append query but the user needs to specify not only the record from a the table they want but they need the option to move the record to wh what ever table they want on the form. Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top