[AccessD] Validation of a control

Are you trying to validate C2 and C3 when you are entering the data into
those fields and after you've made the selection in C1?

Are you looking at the BeforeUpdate event in C1 or in C2 and C3?  

Also - are these fields bound?

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, April 22, 2008 1:24 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Validation of a control

I am not managing to get this right despite numerous attempts. Let's call
the controls C1, C2 and C3. C1 is a combo which contains 5 columns. The
first is its ID, the second and third are the min and max values permitted
in C2. The fourth and fifth are the min and max values permitted in C3.

Perhaps because I am using some fancy code inherited from Gustav and Shamil,
I seem to have lost control over the BeforeUpdate event, so I am leaning
toward the Validation attributes instead. Let's suppose that the item
selected in C1 contains 100, 120 in columns 2 and 3 and 500, 700 in columns
4 and 5. Once the user has selected one such row in the combo C1, how do I
rewrite the validation statements for C2 and C3?

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com