I just had the user input some info with this command:
adoProject.Recordset.Fields("SSN").Value = Trim(InputBox("Enter SSN:"))
Now the info is in: textSSN.text
I would like to do a search of the table to see if the SSN is in the database or not. I'm guessing I would do a 'Seek' type command, but I'm not sure how to set it up. Here is what I'm guessing it should be close to:
If adoProject.Recordset.Seek(textSSN.text) Then
Can anyone tell me if this command would do what I want it to, and if so, how to set it up correctly?
0 · ·