Cannot find record in form?

will

Registered User.
Local time
Today, 08:49
Joined
Jul 11, 2001
Messages
18
I have a form that I created off an query that pulls information from multiple tables. Specifically, I have a table that has first and last name field, when I run the 'add function', it adds the user to the table, but, when I search for the name from the text box on the main form, it says it cannot find the record, I've been using ACCESS for a while and have not been presented with this error before. Its very perplexing because I can see the record in the table, but my form cant find the record...something is not matching up, but I cannot tell what. Any suggestions?
 
make sure your form is using the proper record source in the properties box.
 
You may also try a trim operation on the text to be sure there are no hidden spaces.
 

Users who are viewing this thread

Back
Top Bottom