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

Append Query gives "validation rule violations" after text was edited in Combobox

P: 23
I have a combobox on a form which gets it's Row Source from a table.
I then use an Append Query to save the selected data in the combobox to a file.
Everything works fine.

The Combobox's "Limit to List" property is set to No, thus the user can edit the text in the combobox.

However, the append query gives a "validation rule violations" if you change the text in the combobox.
If you restore the original text in the combobox, the append query runs fine again.

Sep 21 '08 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,770
I presume the question that you meant to ask is something on the lines of "Why doesn't my APPEND query work?"

If so, then you will need to post the code of your query with any relevant explanations.

Please ensure any SQL is formatted in such a way that it is legible.
Sep 22 '08 #2

P: 23

I got it sorted out.
Sep 23 '08 #3

Expert Mod 2.5K+
P: 2,545
Hi Gerhard. We value all questions in the forum, and do our best to help posters in whatever way we can. However, it saves the time and effort of the volunteers who staff the site if you would please not double-post your question. Your current post is much the same as this post, and asking twice does not lead to quicker answers.

Regarding your problem, in neither of the threads have you stated whether or not a validation rule has been defined for the table field concerned, and if so has that rule been violated in some way by changing the data?

Sometimes, error messages accurately reflect what has happened. But you will have checked this, won't you?

Sep 23 '08 #4

Post your reply

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