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?