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

Dan Waters dwaters at usinternet.com
Tue Oct 5 16:10:38 CDT 2004


However, it could be that someone or the system determines the requirement
for the text box to be filled in, and then someone else fills in the text
information.

Dan Waters

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

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



-- 
_______________________________________________
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