Form button to initiate an Append Query

[Rick]

Does anyone know a way to add an object like a button to a form that
will initiate an append query I have written?

Your help would be greatly appreciated.

Rick

 

[Brian]

Rick

Turn your control wizard on. Having a button run stored
procedures and querys is a standard option when designing
forms.

Brian

 

[Mike Painter]

Does anyone know a way to add an object like a button to a form that
will initiate an append query I have written?

Your help would be greatly appreciated.

The button wizard will do this.

 

[Rick]

Does anyone know a way to add an object like a button to a form that
will initiate an append query I have written?

Your help would be greatly appreciated.

Rick

I have now written a macro which starts the append query and that
macro is initiated by a button. This is an OK solution but I
understand that macro's run slowly. If that is true is there a better
way to initiate an append query from a form button?

Your help would be greatly appreciated.

Rick