Access VBADiscuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I don't know how to go about this: I have an order form that can be accessed by different menus. If the order form is opened from MenuA, I want certain controls to be invisible and deactivated, but if the order form is opened from MenuB, all controls are active.
That is what I currently do, but I end up with several versions of a form. When I need to do a change in the original form I have to do the same changes to all the copies and this leaves room to error when I forget a form. I would have appreciated finding a way around this.
Open the form with OpenArgs set to "MenuA" or "MenuB"... then in the load Event of the form, evaluate the OpenArg and set the control.enabled = false or true as appropriate.
Activate or Deactivate controls on forms
Linear Mode
