Field Can not be Updated

[cturner]

I have a form based on a query I built that calculates time worked. you select the worker in a combo box which I created from a query that lists all active employees and their clock no. with clock no being the bound column. The drop down shows the workers last name, first name. When I choose a worker it always gives me a warning the the "Field can not be updated" but after i hit okay it stores everything in the correct field. Why am I getting this error? I tried using just my query and it works perfectly but when I try to use my form is where i run into problems. If you need more info let me know.

Thanks,

 

[Pat Hartman]

There is a conflict in what the combo thinks is the bound column and the combo's controlSource. Remember, the combo will normally be set to show some text value but it will actually need to store a numeric value (its bound column) which is usually hidden. Make sure that your table is set to accept the "id" field rather than the "text" field and make sure that the correct column is designated as bound.