All, using access 2010. I have a data entry form. right now I have it on load to new record. I have an unbound field based on the cust# field from a table. When the user enters a cust number; the corresponding record comes up. But, if the number isn't in the table, nothing happens and the data for the current record exist. I need to write some code where as if a user enters a cust# that doesn't exitst; the form goes blank letting them know that number is not in the table to prevent overwriting data of the current record. Thanks