Refresh table based on form changes

[Sandy]

Hello! I need some assistance with an update after change.

I have tblEmployees that I append new data to on a monthly
basis. The append uses several table sources to record
data about the employee.

I have a form based on tblEmployees.

Users can change values in the table via the form.

Example of a change: User changes the ID of an employee
and the department.

I need to use a new query to "update" the Employee Table
with the corresponding name and department for the ID
change made on the form.

What is the best, most, efficient way of doing this.
(there are many changes the user will have access to
making that I will need to update for but is all ID and
Month driven)

Let me know if you have any questions.

Thank you in advance for your help!

Sandy S.
DBA
(e-mail address removed)

 

[Sandy]

I haven't heard back from anyone.. are you able to assist
me?

 

[Emilia Maxim]

Sandy,

Create a query based on tblEmployee and set the form's RecordSource
property to the query.

If the ID is the primary key, you should really consider changing
this. An autonumber key would spare you much trouble. You can still
keep the ID unique by setting it's index property in the table design.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de