Auto updates to several field

[Dynapen]

I need to build a form that allows users to update the location of a personnell record by simply entering in the Employee ID. This will be used for the clerks that are trackign the record to check several records at once back in to files. Basically, i can build the basic form, i need to know how to have it locate the record, update it to a set of default values, and then start over, preferably without additional keystrokes. <br><br>Everytime i have tried to do this, Access tries to creat a new record for the ID, which is indexed and can't be duplicated. Help me please.....<br><br>

 

[elizabeth]

Structurally speaking, if location is related to EmployeeID, rather than (say) RecordID, your tables should be built that way. In other words, you should not store location multiople times to each record based on EmployeeID, but have a foriegn key for Location ID in the employe table, or whatever. EmployeeID should be linked to RecordID and also to Location(ID). Hope that makes sense