Hi i have 1 form but i want to store the info put on that form into 2 tables, is this possible? what it is is im making an enquiry database where you put in whatever personal details you can about the enquirer then the details about the actual enquiry and i want these to go into two seperate tables.

if possible i would like when typing in details about an equirer for it to autofill in the rest of the appropriate fields if an enquiry has already been made by that perosn but save all this as a new record rather than copying over the old enquiry. any ideas??

Create a query using the two tables (be sure that there is a relationship between the two tables). Drag the fields you want from each table into the QBE grid. Base your form on the query.

This article http://support.microsoft.com/support/kb/articles/Q136/1/27.asp?LN=EN-US&SD=gn&FR=0 will show you how to fill a new record with data from the last record entered. I do not see why you could not modify this code to autofill from a secific record instead....

HTH,
Jack