Field error: the value you entered isn't valid for this field...

[nimarii]

Hello,

I have a form with multiple comboboxes - all of which look up values in their respective tables. All of these tables have 2 fields: ID# (autonumber), & FieldName. For example, i have a combobox called "Term" that has a table with ID# & TermLength as its fields. The combobox is set to 2 columns, with only 1 bound column, so the ID# shoudln't be displayed when clicking on the drop down arrow, but when queried in modules, will return the ID# value.

All of the comboboxes are working except for the "Term" combobox. It is set up exactly as the others are in the tables and in the form. The data appears as it should, but everytime I click on the drop down arrow, I get the message:
"The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the fieldsize setting permits."

Can anyone advise on whats wrong?

Thanks!

 

[GingerR]

Is the combo boxes bound? I mean does it have a Control Source where after you select something it goes into a field in a table? If so, what is the data type of the field it's going in to? And what is the data type of TermLength? Sounds like there might be a mismatch there.

 

[nimarii]

thanks for the reply! the combo-box is bound, the data type of the field its going into is "Text", and the data type of termlength is "Text" as well.

i've been searching high and low for a mismatch, but i really cant seem to find any discrepancies....not to mention that this field is set up just like a few of the others, and those are all working...

 

[GingerR]

isn't the TermID (bound) going into the field? Shouldn't the type be Integer in the table?

 

[nimarii]

hmm, actually, the termID isn't being recorded in the table, its the other field that is. here's what the lookup tab for that field looks like on the table:
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT Terms.ID, Terms.Terms FROM Terms;
Bound Column: 1
Column Count: 2
Column Headers: No
Column Widths: 0";1"
List Rows: 8
List Width: 1"
Limit to List: Yes

This is also how the field is set up on the form to be displayed...(2 columns, ID field size is set to 0....)

 

[PHV]

the termID isn't being recorded in the table, its the other field that is
So the BoundColumn should be 2.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nimarii]

Thanks PHV, changing the boundcolumn to 2 seems to have worked! i'm not sure that i understand why, but i'm very grateful

thanks GingerR for your help!

 

[GingerR]

BOUND = the thing that's going to be written to your table.