Hi,
I have a continous form FormA that displays data from Tbl1 only. Created a click procedure on fldA that opens FormB with the link Criteria to open the selected record on FormB. FormB is a Single Form that only selects that current record. See code below from FormA
Private Sub FldA_Click()
strLinkCriteria = "[Tbla].[FldA] = '" & Me.FldA& "'"
DoCmd.OpenForm "FormB", , , strLinkCriteria, , , strSndArgs
End Sub
I have used the same code in other Forms that works similar and they work fine, but in this form it open the form and displays the first record on Tbl1.
I have check that the linkcrtieria passed is correct and also compared the properties of FormB against the properties of the forms that does work and everything seems to be in order. I do not want to redevelope the form because I am falling behind with the project.
Please help.
Thanks
Earl