Keyboard Shortcut

[phuser]

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]

On the OnClick event on a command button on the subform try:

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

PJ

 

[PJFry]

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.

 

[phuser]

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:

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?