I have a form that has a checkbox. I want the checkbox to be checked (true) if records exist in tblOutpurchase where the field EstN is equal to the field "txtRealEstN" on the form. Here is my code for teh oncurrent event of the form which is not working. Can someone spot the problem for me?
If Len([tblOutsidePurchase]![EstN] & Me.realEstN & "\*.*") = 0 Then
Me!chkbxHasOP = False
Me!chkbxHasOP = True