Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2008

Tip: Looking for answers? Try searching our database.

Keyboard Shortcut

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
phuser - 30 May 2008 17:13 GMT
I would like a command button to go back from the subform to a specific cell
on the main form, right now I am using the
CTRL+TAB to perform this but would like to have a command button, is this
possible?
PJFry - 30 May 2008 18:02 GMT
On the OnClick event on a command button on the subform try:

Forms![Main Form Name Here]![Field on Main Form].SetFocus

PJ

> I would like a command button to go back from the subform to a specific cell
> on the main form, right now I am using the
> CTRL+TAB to perform this but would like to have a command button, is this
> possible?
phuser - 30 May 2008 18:20 GMT
Absolutley Awesome, little thing but it will save so much time!!!!!!

Thank you so much

> On the OnClick event on a command button on the subform try:
>
[quoted text clipped - 7 lines]
>> CTRL+TAB to perform this but would like to have a command button, is this
>> possible?
PJFry - 30 May 2008 18:12 GMT
And I  should add that what I suggested is not a keyboard shortcut nor does
it mimic one.  It simply moves the focus to a specific field on a form.  You
can modify this to go to any form and field.  

> I would like a command button to go back from the subform to a specific cell
> on the main form, right now I am using the
> CTRL+TAB to perform this but would like to have a command button, is this
> possible?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.