Make fields unavailable

[JR]

In a form, I'm trying to make certain fields only
available to a user based on his previous answers. For
example, let's say the question is: "Did you set an
appointment?" w/ a Yes/No option. If he answers "Yes,"
then the Date, Time, & Location fields become available
to him. If he answers "No," they're unavailable to him.

I'm still learning Access and am stuck. Thanks in
advance.

JR

 

[Jim Allensworth]

In a form, I'm trying to make certain fields only
available to a user based on his previous answers. For
example, let's say the question is: "Did you set an
appointment?" w/ a Yes/No option. If he answers "Yes,"
then the Date, Time, & Location fields become available
to him. If he answers "No," they're unavailable to him.

I'm still learning Access and am stuck. Thanks in
advance.

JR

Basically, you would set the fields Enabled property depending on the
input from checkbox chkSetAppt. Use the After Update event to modify
the controls. (BTW, the Date & Time should be combined)
For example ...

Me.txtDateTime.Enabled = Me.chkSetAppt
Me.txtLocation.Enabled = Me.chkSetAppt

It sounds like the default of txtDateTime & txtLocation would be NOT
enabled - they would be enabled or not depending on the response to
chkSetAppt.

- Jim