Tabing from one subform to another

[Guest]

I have created a macro that will allow the user to move from one subform to
the next subform both are within a main form. The marro works great, except
when tabing from the last field in the first subform to the first field in
the second subform the first subform apears to go blank.

I know the data is still within the table, after testing, but this is the
type of thing that will drive my users nuts. What am I doing wrong or is
there a setting I am missing?

Thanks for the help

 

[strive4peace]

Hi Jacqueline ,

perhaps that is because you are tabbing to a new record...

set the form Cycle property (Other tab) to --> Current Record

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Awsome! that worked thanks so much

 

[strive4peace]

you're welcome, Jacqueline happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Hi Jacqueline

Would you mind tell me how did you created a macro that allow user to move
from one subform to the next subform?

Thank you very much
Hong

 

[strive4peace]

Hello Hong,

in the code behind the first subform:

Me.Parent.subform2.SetFocus
Me.Parent.subform2.Form.controlname2.SetFocus


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Thanks

Hello Hong,

in the code behind the first subform:

Me.Parent.subform2.SetFocus
Me.Parent.subform2.Form.controlname2.SetFocus


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

you're welcome, Hong happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*