Can one run an apend query from an after update event with values ... 1

[Focusfocs]

Hello All,
The questions are: Can a person run an apend query from an after update event using values that are supplied by unbound textboxes on the form? If so how? TIA

 

[TheAceMan1]

How are ya Focusfocs . . . . .

[blue]Can a person run an apend query from an after update event using values that are supplied by unbound textboxes on the form?[/blue]

Yes! . . . using the [blue]DoCmd.OpenQuery "[purple]QueryName[/purple]"[/blue]

In the design view of the query, set custom fields with form references to their targets:

[blue]Dat1:Forms!YourFormName!YourTextboxName[/blue]

Of course the referenced form has to be open . . .

Be careful appending [blue]pimarykeys[/blue] against those indexed as [purple]No Duplicates[/purple]. You may want to check existance first, as an error will be raised.

Appending to tables with [purple]AutoNumber[/purple] PK should not include the PK.

See Ya! . . . . . .

 

[Focusfocs]

Thank you TheAceMan1! I will give that a whirl! Thank you so much for your response and helpful hints!