Warning while Traversing a Query in MS Access

[somcool]

I am facing an error while traversing a query in MS Access
Details - When I click a button, a form which has the query opens up. There are certain fields which are in the form of combo box in the query. The query comes from a table which picks values from another table. When I try traversing the query through TAB button, I get the following warning - "The value you entered isnt valid for this field. For example you might have entered a text value in a numeric field". This warning arrives while traversing through combo box. Is there a way to disable this warning?

PS- Tried Docmd.Setwarnin gs. This didnt seem to work.


Any help is highle appreciated.

[Stewart Ross]

Hi. Because the error message is shown when you pick an entry from the combo it suggests that the combo list values and the values expected for the field to which it is bound in your form's underlying recordsource table or query are not compatible - possibly even of different data types. I suggest that you eliminate the source of the error, not the error message.

-Stewart