I have a table that contains the names and info for all employees. In the
related form, when a person enters that employee's #, the form populates
that person's personal info. An attached subform links to a case table
which tracks cases related to each employee. Everything is working except
for a basic search. Everytime an employee's info is called up, to look at
previous cases or personal info, a new case is added in the Case Table. I
created a delete query that solves the problem after the fact by deleting
blank records. Is there a way to stop that from occuring, and only adding
a new record when the >* button is pressed? Any help would be
appreciated. Derek