cheryl27284
Technical User
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?