Run more than one query from event procedure

[Cpreston]

Hi

I want to run 3 querys at once at a click of a button.

A delete rows, make main table and update table query.

I am sure this is possible but could someone advise how the code should be please or point me to a good link.

Thanks

 

[Cpreston]

I have managed to get this working through the embedded macros, but how would this be achieved in event procedure.

I am sure you sued to be able to change the macro to event procedure and it created the code for you??

Thanks

 

[PHV]

Have a look at the DoCmd.RunSQL method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886