I have a combo box that picks salesman's initials.
The source is a table that has:
I have in the combo box propoerties data section:
Row source type Table/Query
Row Source TblSalesman
Bound Column 2 (This is where the initials are)
Whenever I try to enter the initials in the box, an error comes up saying the that it won't take it and I may be using text where a number is supposed to be used.
That is not the exact message but that is what it says.
I did indeed have it as you said in your example.
No hidden columns
I figured it out though.
It was not fair. I really did not give you guys enough information.
My source table for our (work order) did not have the salesman as a combo box. Also it was looking for text not a number. Well the salesman ID is obviously a number and it gave me errors.