Conditional Visibility Based on Date

Question

I have a few questions regarding having Access form fields conditionally visible:

1. I would like to make a field only appear if the Date of Birth field indicates the individual was born before 01/01/1991, but I can't seem to get a condition based on a date to work correctly (it always appears regardless of the date in the Date of Birth field).
2. I can't seem to get date fields that conditionally appear based on another field to permit data entry. I used the code below.
3. I also can't get check boxes that conditionally appear based on another field to permit data entry. I also was using the code below.

If STATUS.Value = "SUBSTITUTION" Then

    Me.OFF_SUSPENSION.Visible = False

End If

I am using Access 2007-2010

Answer 1

First, youu need to understand you don't have fields on a form, you have controls that may or may not be bound to fields in a table. This is a subtle but important distinction.

1. In both the On Current event of the form and the After Update event of the DOB control you would include a line of code like:

If Me.datecontrol < #1/1/91# Then

     Me.othercontrol.Visible = True

Else

     Me.othercontrol.Visible = False

End If

This could be shortened to:

Me.othercontrol.Visible = Me.datecontrol <#1/1/91#

2. To allow a field to have data entered, they need to be bound to a field in a table.

3. same answer as 2

Answer 2

Thank you! I thought I had them bound to a field, but I must've done something incorrectly. I removed them and re-added them and it worked like a charm!