By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

How to test if a command button was pressed on the form?

P: 1
Using Access 2000 with VBA within an Access project. I have a form "Purchase Order" which is used to either duplicate an existing PO or create a new PO. I need to determine within the forms "BeforeUpdate" event if the "Duplicate PO" command button was pressed.
I'm new so please point me where this may already be described. Of course details would be welcomed.
Thanks.
Jan 8 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
In your code for the 'Duplicate PO' button, you could save a boolean (True/False) condition. It would have to be stored in a Global (available to all procedures in the module) variable to be available to check in the 'BeforeUpdate' event.
Jan 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.