Avatar of dailymeat
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?
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Rey Obrero (Capricorn1)

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

docmd.openform me.name, acdesign
PatHartman

What are you trying to do?
dailymeat

ASKER
Want to open form in design view, go to a command button,  property event
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
PatHartman

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.
Rey Obrero (Capricorn1)

my post at #a42041204  already answered your question.
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
dailymeat

ASKER
It worked!, thank you
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

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

Just note the cautions we all mentioned...

JeffCoachman
Rey Obrero (Capricorn1)

@jeff
that is nice. learned something new today ;-)
Jeffrey Coachman

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...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck