I need a quick, easy way to search a database for a value (e.g., SSN) before the entire multiple field record has been entered. This has to be done so that we don't have any duplicate records in the database. Yes, I know, I can set 'no dupes' on that field's property - but they can still go ahead and enter the entire record before finding out (when saving) that it's a dupe SSN.<br><br>My idea was to have the user enter the SSN of the "new" customer, do a quick search of existing records and, if no match was found, bring up the data entry form. If a match IS found in the search, I want to bring up the existing record for edit.<br><br>Any suggestions? I've written a bunch of (convoluted!) code, tested several things, and still don't have it "quite right" for the user.<br><br><sigh><br><br>Thanks in advance!<br><br>Tom