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!

Copying a whole record into another table 1

Status
Not open for further replies.

Dibblet

Technical User
Jul 14, 2005
20
0
0
GB

I would like to set up a form so that when a box is checked to finalise a form it copies the new record from one table into another as new record. How can I do this?

The tables don't currently have the same fields names and I could make it so they do, but is this really required?
 
Changing the field names wouldn't be necessary. A simple select and Insert would accomplish this task.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top