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?

Try requerying the form.

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.