Form button to initiate an Append Query

R

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
 
B

Brian

Rick

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

Brian
 
M

Mike Painter

Rick said:
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.
Click to expand...
The button wizard will do this.
 
R

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
Click to expand...

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
 
Top