Combo Box problem

[Guest]

On my form is a text box (size 60) called Organization. Rather than use the
record selector to find the appropriate record, I decided to change this
field to a combo box to allow the user to select from the drop down or to
enter a letter & it jump there. It seems to work, but I keep getting the
following Access message "The value you entered isn't valid for this field".
I don't see what's wrong ?

 

[Guest]

Check the type of the field that is in the ControlSource Property of the
combo, and compare it to the type of the field that the combo source is
trying to insert to this field, the BoundColumn Property will tell you which
field.

 

[Warrio]

No! the message that you got means that what you've entred into your combo,
is not a value that is listed into the choice proposed by your combo!

if you want to do not limit and let the user enter whatever he wants (even
values that you do not propose) Set the proprety into the tab Data, Limit To
List = No

but if you do so, the user migh enter a value that you don't have on your
form, and you wouldn't be able to jump to the correct data.