[AccessD] fill in x field if y field is checked

John W. Colby jwcolby at colbyconsulting.com
Tue Oct 5 15:45:06 CDT 2004


Are you a programmer?  

In plain VB, in OnClick of the checkbox, check if the box is checked or
unchecked.  If checked, place the cursor in the text box and open a message
box or some such.  If unchecked, clear out the text box.  You would want to
also do things like disable the text box unless the check box is checked
etc, or alternately if the text box has something entered, then check the
check box.  

This is in fact a facet of normalization where you have the same information
stored in more than one place.  The check box stores the fact that
contributions are restricted, but the simple fact that something is in the
text box stores the fact that contributions are restricted.  You don't need
the check box at all, it is a convenience which  raises ugly issues such as
how to keep the two controls in sync.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of augusta
Sent: Tuesday, October 05, 2004 4:00 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] fill in x field if y field is checked


I need to know how to make a field required if another field is checked. For
example: If the contributions are restricted, then fill in the restricted
reason.

Can anyone help  - in plain English?

Thanks Augusta



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






More information about the AccessD mailing list