YES/NO Option

[Beeyen]

Good Day,

I am trying to link the Yes and No option, where selecting yes enters the
date/time in field 1 and field 2 is grayed out and If no option is selected
both fields are gray.

Can anyone provide assistance?

Thanks

 

[Linq Adams via AccessMonster.com]

I'm not real sure what Field2 has to do with anything here, since you've not
said changing it regardless of what the Option Button does. But in Design
View set the Enabled Property of both to No.

Then

Private Sub OptionButtonName_AfterUpdate()
If Me.OptionButtonName = -1 Then
Me.Field1.Enabled = True
Me.Field1 = Now
Else
Me.Field1.Enabled = False
Me.Field1 = Null
End If
End Sub

 

[Beeyen]

Good Day Ma'am,

Thank you for the response and the direction.

Field 1 = Handling
Field 2 = Resolved

If the radio button next to field 1 with options yes and no, where yes is
selected then the date in field 1 is populated with the current date, and
field two is populated with the current date when the option yes next to the
field is selected

If the radio button next to field 1 is no then both field 1 and field 2 is
automatically grayed out.

Thanks again for any assistance you can provide.