Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Form Automatically Creates New Records


Message #1 by "Derek Stewart" <derekstewart@y...> on Wed, 19 Mar 2003 17:28:13
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 

  Return to Index