I've successfully populated a subform from code on the main form using:

Me.frmSubJobList.Form.RecordSource = strSQL

but I can't see how to navigate the records. This approach looks hopeful..

    Me.frmSubJobList.Form.SetFocus
    DoCmd.GoToRecord , , acLast

But the first line generates the helpful error, "There is an invalid methond in an expression" !
Can anyone point me in the right direction please!

Thanks

Bob

When you say "navigate the subform" what are you trying to do? Subforms are usually dependant on the main form so the records in the subform only refer to a record in the main form, and navigation usually involves scrolling.

mmcdonal

Thanks mmcdonal, my subform is not linked to the main form. I found the answer - I should have used Me.frmSubJobList.SetFocus rather than referring to the Form. This works fine!

Thanks again.

Bob