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

[Gerhard]

Hi
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.

Thanx,
Gerhard

[NeoPa]

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.

[Gerhard]

Thanx

I got it sorted out.

[Stewart Ross]

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?

-Stewart