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