I have a Private Sub that is supposed to open a form with one record as the Control or Row source
This is the code that is supposed to open the form and show me the record I clicked on.
Private Sub List78_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Call_Ticket"
stWhoCalled = "DirectAccess"
stLinkCriteria = "Forms!Call_Ticket!Service_Tag_No = " & Me!List78
DoCmd.OpenForm stDocName, , , stLinkCriteria
This is the code that populates the form when it opens. It is my understanding that stLinkCriteria will cause the record I want to be selected as the rowsource.
If stWhoCalled = "DirectAccess" Then
Me.RecordSource = "OpenCalls"
Me.Caption = "You are Editing Open Calls"
The problem is that I am seeing the first record in the "OpenCalls" query defined in Me.RecordSource
I want to see the record specified by the List78 value from the form where I clicked.