task being updated on different key?

  • Thread starter Thread starter JR
  • Start date Start date
J

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
 
Apparently you did not bind the combo to a field in your table so that the
selection is stored.
 
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
Click to expand...

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.
 
Back
Top