dailymeat
asked on
In Access, is there a command to go to a control in design view from a command button?
In Access, is there a command to go to a control in design view from a command button?
What are you trying to do?
ASKER
Want to open form in design view, go to a command button, property event
OK, we got that much. What do you want to do at that point? Why do you have to put focus on the control? Once the form is open in design view, you should be able to reference any control directly. Keep in mind that Access is a Rapid Application Development tool intended for use in creating data-centric applications. It isn't a graphic design tool so there is a limit to what you can actually do programmatically in design view.
Are you making a tool for yourself because this is not something you would ever do in an application you built for others to use.
Are you making a tool for yourself because this is not something you would ever do in an application you built for others to use.
my post at #a42041204 already answered your question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It worked!, thank you
Thanks, ...it took me a while to get the syntax just right.
Just note the cautions we all mentioned...
JeffCoachman
Just note the cautions we all mentioned...
JeffCoachman
@jeff
that is nice. learned something new today ;-)
that is nice. learned something new today ;-)
Cap, ...Yeah, ...
For some reason, years ago, I remember a question on this, ...I think Scott posted the syntax...
;-)
I was not even certain the syntax still worked...
For some reason, years ago, I remember a question on this, ...I think Scott posted the syntax...
;-)
I was not even certain the syntax still worked...
docmd.openform me.name, acdesign