task being updated on different key?

[JR]

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

 

[KARL DEWEY]

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

 

[John W. Vinson]

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.