Setting focus to other db's form

[Lars Brownies]

With appAccess.DoCmd.OpenForm "Orders" I can open another mdb's form. Is it
also possible to move the focus to a specific field of that form by using
the appAccess variable.
I tried appAccess.forms.Orders.MyField.setfocus but that doesn't work.

Thanks,

Lars

 

[tina]

if you used the exact syntax you posted, that may be the problem. try

appAccess.Forms("Orders")!MyField.SetFocus

hth

 

[Lars Brownies]

I tried variations of that, but not just that one.
Thanks, it works.

Lars

 

[tina]

you're welcome

I tried variations of that, but not just that one.
Thanks, it works.

Lars