Problems Writing what is displayed to a specific Field!!!

R

Richard C

I have been trying to create a template for my database,
for my task system. What I have is the Template for it, it
will display the task name and Outline, and they are fixed
values in a combo box. They cant be changed, this allows
the user to edit the other details. The problem that has
cropped up, is it will display in the form what I want,
but it doesnt write the information to the corresponding
field, it just writes an integer, which I am guessing is
the Task_ID which is an auto number.

The Task outline and Name come from another table called
Task_Templates, they are what fills the combo box with the
options. I want the infomation to be written to the
Task_outline etc in my Traffic_lights table, which is
where all the tasks are stored. The expression below is
the Row Source and is bound to column 1. Is there anything
in it that would mean the Task_ID is written rather than
the Task_Outline?

SELECT Task_Templates.Template_ID,
Task_Templates.Task_Outline,
Task_Templates.Task_Outline FROM Task_Templates ORDER BY
[Task_Outline];

Richard
 
Top