How to call VBA function on command event in access 2007?
-
Hi All I am new with VBA in access. I have two buttons on access form.when i click on 1 button,my vba code has to run. how to do that? pls help me. Thanks
-
Hi All I am new with VBA in access. I have two buttons on access form.when i click on 1 button,my vba code has to run. how to do that? pls help me. Thanks
Open the form in design view, double click on the button. That should put you in a code window in the buttonX_Click event (where buttonX is the name of your button). Now add a call to your code (or place your code here if its not in a sub/function. Buy a book on Access programming if you intend to do any more - this is something that is one of the first steps in Access programming.
Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis