Link Criteria no working when opening new form

[ETCallHome]

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

[ETCallHome]

Hi,

I resolved the issue... if anyone does experiences a similar problem, check the if you changed the allowedits, allowadditions, etc properties of the form. I set these properties to false on the open form event, as I am using one form to enquire, modify and add records to the tables and did not want the enquire function to do anything on the form...

I remove the code and all is working fine again.

Thanks to those you checked the thread.. learning everyday.