Error Message

[Guest]

Hello,

I keep getting an error message when trying to select an entry from a Combo
Box which says:

"The value you entered isn't valid for the field."

The field in question is a field of type "Text" from my Employee table who's
fields are:

EmpID ( Autonumber )
Emp_Name ( Text )
Job_Title ( Text )
Dept ( Text )
Notes ( Memo )

Here's the contents of table Employees:

EmpID Emp_Name Job_Title Dept Notes
1 Covati, Sue
2 Ho, Anh
3 Tan, Kristin

If I ignore the error and select the second name "Ho, Anh" from the Combo
Box and then navigate to the next record, the Employees table data now looks
like this:

EmpID Emp_Name Job_Title Dept Notes
1 2
2 Ho, Anh
3 Tan, Kristin

All fields in the first record of Employees table get overwritten with the
record number of whatever name is selected from the Combo Box.


-Simon

 

[Guest]

simon,
it seems like you r trying to update the table using the combobox. what
exactly are you trying to accomplish?

do u hv codes in your combobox (e.g. click event) that update employeename?

 

[Guest]

Jeff,

I think I found the problem. Being fatigued from lack of sleep causes all
sorts of problems. I'm gonna catch a few hours now though. Thanks for
replying Jeff and my apologies.

-Simon