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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

"Emilio" wrote:

> 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,
.

Quantcast