Populating a table when a new record is entered in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
After clicking a "New Record" button, a form is opened to create a new
record in a form. The user should populate four fields at which time when a
combo is populated it should trigger the After Update and run an append query
to a table. My question are:
1) The append query should run only on a new record, how can I do this only
when is a new record and not when the user is just updading a record in the
form?
2) Can I create an append query programmatically without saving a query in
the database?
Thanks,
 
If Me.NewRecord = True Then ...
will tell you if you are on a new record or not
DoCmd.RunSQL "INSERT INTO ...
will programatically create an append statement without creating a query
 
Back
Top