On click add record

  • Thread starter Thread starter plally
  • Start date Start date
P

plally

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".
 
Back
Top