By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Warning while Traversing a Query in MS Access

P: 1
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.Setwarnings. This didnt seem to work.

Any help is highle appreciated.
Mar 13 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
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.

Mar 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.