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

Stuart McLachlan stuart at lexacorp.com.pg
Tue Oct 5 17:08:49 CDT 2004


On 5 Oct 2004 at 16:00, augusta wrote:

> 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?
> 
It's called "validation"  :-)

In your from's Before_Update event procedure, you need to do something 
like:

If  Resricted = True and isnull(Reason) then
   Msgbox "You must give a reason for restricting contributions"
   Cancel = True
   Me.Restricted.SetFocus   
End if






-- 
Stuart





More information about the AccessD mailing list