Can you ignore table validation on query append?

[missujerr_junk]

Hello,

I have a table that has validation:
IIf([Document 1] Is Null,[Document 2] Is Not Null And [Document 3] Is
Not Null,IIf([Document 1] Is Not Null,[Document 2] Is Null And
[Document 3] Is Null))

This is because when my user fills out their form, they must select
one choice from List A OR one item from List B and one item from list
C.

My problem is that I have an append query to add any new hires to the
table in an autoexec. The append query is failing because I am not
updating any data for the above Documents. Is there anyway for me to
get around the table validation on my append?

Any help would be greatly appreciated! Thanks!

 

[John W. Vinson]

Hello,

I have a table that has validation:
IIf([Document 1] Is Null,[Document 2] Is Not Null And [Document 3] Is
Not Null,IIf([Document 1] Is Not Null,[Document 2] Is Null And
[Document 3] Is Null))

This is because when my user fills out their form, they must select
one choice from List A OR one item from List B and one item from list
C.

My problem is that I have an append query to add any new hires to the
table in an autoexec. The append query is failing because I am not
updating any data for the above Documents. Is there anyway for me to
get around the table validation on my append?

Any help would be greatly appreciated! Thanks!

No. It wouldn't be validation if it were possible to enter invalid data.

If you want to restrict user entry through the form but permit it through an
append query, remove the table validation rule and instead use the Form's
BeforeUpdate event to enforce the rule.