task being updated on different key?

I am designing a form that uses a combo box to look up or add a task.

There are only two columns in the table: "Key" (auto number) and "tasks"
(text)

When a task is selected from the combo box (or the title of a new task is
entered), it somehow winds up replacing whatever task # 1 was and task #1
disappears.

How do I prevent this from happening?

I need employees to be able to select the task they are working on and enter
hours worked.

Thanks,
JR

Apparently you did not bind the combo to a field in your table so that the
selection is stored.

--
Build a little, test a little.


"JR" wrote:

I am designing a form that uses a combo box to look up or add a task.

There are only two columns in the table: "Key" (auto number) and "tasks"
(text)

When a task is selected from the combo box (or the title of a new task is
entered), it somehow winds up replacing whatever task # 1 was and task #1
disappears.

How do I prevent this from happening?

I need employees to be able to select the task they are working on and enter
hours worked.

Thanks,
JR

On Tue, 20 Oct 2009 07:18:01 -0700, JR wrote:

I am designing a form that uses a combo box to look up or add a task.

There are only two columns in the table: "Key" (auto number) and "tasks"
(text)

When a task is selected from the combo box (or the title of a new task is
entered), it somehow winds up replacing whatever task # 1 was and task #1
disappears.

How do I prevent this from happening?

I need employees to be able to select the task they are working on and enter
hours worked.

Thanks,
JR


This combo box needs to be "Unbound" - it should have a blank Control Source
property in forms design view. My guess is that you have it bound to the task
field in the table; if so, whatever the user selects will update that field.
--

John W. Vinson [MVP]