Run an Append Query from a Form

[wizcow2]

Is it possible to run an append query from a form?

I would like to click a button on my form and have the subform fill with the results of an append query.

Any ideas?

Tom

 

[bradcccs]

Attach the following code to your button

DoCmd.SetWarnings False
DoCmd.OpenQuery "YourAppendQueryName"
DoCmd.SetWarnings True

Note: the Setwarnings lines stops the "You are about to ...." default messages from annoying you.

You will then have to requery your subform to display added records.

HTH

Brad.