Continuous Form Not Updating Tables Correctly

I have a continuous form that is using a select query to populate all of the bound controls. The drop downs and text boxes are displaying the values from the correct places. But, the form is not updating in the places I expected. Any information/help would be greatly appreciated!



The select query that is being used to populate, combines information from 3 tables.

1. 'TimeEntries' table (the one that I want records to be updated in). This holds employee ID, and numeric values for Project Name and Project Task.


2. 'ProjectInfo' table (nothing should be updated here). This table holds other details about the project (ex. Project Name) that is used to populate a combo box.


3. 'ProjectTasks' table (nothing should be updated here either). This table holds details about project task (ex. Task Description) that is used to populate a combo box.

The issue I am having is that when records are updated on the form, they are adding records to all 3 tables that are a part of the query, instead of just updating the time entries table.



Record Source (form) = Select Query "EmployeeTimeEntry"



Thanks in advance. :confused:

Continuous Form Not Updating Tables Correctly