Form recordsource

[mbraden]

Hello-

I have a main form with multiple subforms that filter based on the main
form.

On the main form is a textbox for SSN. Upon entry of a number in the
SSN textbox (either current record or new record), I would like to
perform a query that checks for duplicates in 2 different tables. If a
record is found, return that record to the main form then refresh my
subforms. However, returning a new record to my main form causes the
form to save with the newly entered SSN which is causing referential
integrity problems. Is there anyway to stop the main form from saving?

 

[Guest]

Make your search entry text box an unbound form and use it as criteria for
the query.