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?