RE: Populating a table when a new record is entered in a form
- From: Dennis <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 15 Jun 2005 01:19:02 -0700
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,
.
- References:
- Prev by Date: Re: Background Colors
- Next by Date: Re: Can I lose new record on sub form?
- Previous by thread: Populating a table when a new record is entered in a form
- Index(es):
Relevant Pages
|
