go to record in navigation form (1 Viewer)

[spinkung]

hi

i'm trying to go to a record in a form based on the selected record of a subform. both form are in a navigation form and i get an error when i try to run...

DoCmd.GoToRecord acDataForm, "frm_PO_employee", acGoTo, Me.CurrentRecord

the error is The object 'frm_PO_employee' isn't open

thanks

 

[John Big Booty]

You need to use the FindRecord method, rather than the GoToRecord method.

 

[spinkung]

thanks

i had to do make sure the focus was on the form i was trying to find a record on :

Form_frm_PO_employee.Form.userid.SetFocus
DoCmd.FindRecord userid, , True, , True