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

How do i create a validation rule in a table

P: n/a
In my table i would like to create a validation rule for a yes/no
field. I would like it, to only allow you to check yes, if two other
fields are already ticked as yes.

Example;

Field 1: Order confirmed (yes/no)
Field 2: Order ready to ship (yes/no)
Field 3: Shipped (yes/no)

I would like a validation rule, which lets you check Field 3: [Shipped]
only if field 1[Order confirmed] & 2[Order ready to ship] are checked.

Any assistance would be greatly appreciated.

Regards,

BJ

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AFAIK, you can only do that in the BeforeUpdate event of the control in
your form. You can't write the same really crazy validateion rules
that you can do at table level like you can in oracle.

Nov 13 '05 #2

P: n/a
Open the table in design view and go to properties. In the validation rule
of the table, enter the following:

IIf(([order_confirmed]=False Or
[order_ready_to_ship]=False),[shipped]=False,[shipped]=Null)

I've tested this here and it works fine!!!

Mark
<pi********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
AFAIK, you can only do that in the BeforeUpdate event of the control in
your form. You can't write the same really crazy validateion rules
that you can do at table level like you can in oracle.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.