Can't Navigate Records On Linked Form

[cmcquain]

I cannot navigate through records once I link one form to another. Any help would be great. Thank you!


Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmMember"
stLinkCriteria = "[FirstOfPatient ID Carrier]=" & "'" & Me![Patient ID Carrier] & "'"
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[Yeldarb]

Can you explain more, please?

Is this a form to subform situation?

Are you trying to query the recordsource from one to another?

 

[cmcquain]

It is a form to a form that has a subform.

 

[Yeldarb]

In the design tab of the main form, you can select the subform name in the property sheet.

Once the subform property sheet is selected, you can find the Link Master Field and Link Child Field properties under the Data Tab.

Enter the Patient ID Carrier fields properly here.

In VBA set focus to the subform to navigate subform records...

Forms.frmMain.SetFocus

Forms.frmMain.[tbl subform].SetFocus

DoCmd.GoToRecord , , acNext

Hope that is what you are looking for

 

[cmcquain]

Thank you. That worked