We help IT Professionals succeed at work.

In Access, is there a command to go to a control in design view from a command button?

dailymeat
dailymeat asked
on
76 Views
Last Modified: 2017-04-28
In Access, is there a command to go to a control in design view from a command button?
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
sorry, but none. You can put the form in design view from a command button click with

docmd.openform me.name, acdesign
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
What are you trying to do?

Author

Commented:
Want to open form in design view, go to a command button,  property event
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.
CERTIFIED EXPERT
Top Expert 2016

Commented:
my post at #a42041204  already answered your question.
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
It worked!, thank you
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Thanks, ...it took me a while to get the syntax just right.

Just note the cautions we all mentioned...

JeffCoachman
CERTIFIED EXPERT
Top Expert 2016

Commented:
@jeff
that is nice. learned something new today ;-)
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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...