On click add record

I have a form that I use to enter new records into a table (tblNewJobs). On
the same form, I also use a macro on form that appends the new records as
well as other information to another table (tblJobsArchive). The problem is
that I must use the "enter" key after entering data the last field on the
form so that the record gets entered into (tblNewJobs). What type of command
would I use in the macro to add the last data entry to the table in lieu of
using the "enter key".

Try GoToRecord, then set record to New
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"plally" wrote:

I have a form that I use to enter new records into a table (tblNewJobs). On
the same form, I also use a macro on form that appends the new records as
well as other information to another table (tblJobsArchive). The problem is
that I must use the "enter" key after entering data the last field on the
form so that the record gets entered into (tblNewJobs). What type of command
would I use in the macro to add the last data entry to the table in lieu of
using the "enter key".