Hi,
I have a form with an unbound text box called SSN. I want user to enter a Social Security Number there and click a button which runs the following:
DoCmd.OpenForm "frmDropStudents", , , "[SocialSecurity] = " & [SSN]
frmDropStudents is opening as "filtered" showing a blank record.
This doesn't work either (same result as above):
DoCmd.OpenForm "frmDropStudents", , , "[SocialSecurity] = " & Me.SSN
Can anybody help?
ps ACCESS 2007