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

John W. Colby wrote:

>Are you a programmer?  
>  
>

no I am far from it. I wish that I were, but too many things to learn! 
However, I have deceided that I need to learn more about Access and it 
"power". So I think that I need a more detailed explaination?

I think that the user would like to be able to check the box first

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