Event From SubForm1 Open A Form to Specific Record in SubForm2

[Richard Anderson]

This is the Code I have so far...

DoCmd.OpenForm "frmJobInfo", acNormal, "", "[JobID]=" & JobID, , acNormal

This code is in the Click event on the form frmJobsList which is inside a subform called SubJobsList. There is another subform called SubJobInfo. I need the form in the above code to be directed to open inside the subform SubJobInfo.

How can I change the code to make this happen?

I tried the following but is doesnt open to the record I click in the form frmJobsList. I think I need to somehow combine the 2 methods into a single command.

Forms!frmMain!SubJobInfo.SourceObject = "frmJobsInfo"

[Richard Anderson]

I tried to combine them but I got a syntax error...

Forms!frmMain!SubJobInfo.SourceObject = "frmJobInfo", acNormal, "", "[JobID]=" & JobID, , acNormal