Radio Buttons in Subforms

[Beeyen]

Good Day,

I am using Access 2003 and continue to be challenged by this, and thought I
would describe my dilemma a bit differently. If you could share your thoughts
or possible solution to the questions below that would be great. Thanks in
advance.

The following information is in a subform;

Exceptions Handling [Date/Time Field] [radio button (yes)] [radio button
(no)]
Exceptions Resolved [Date/Time Field] [radio button (yes)] [radio button (no)]

If yes is selected, then the Date and Time Field is auto populated with the
current Date/Time and the Resolved [Date/Time Field] is auto populated with
the current Date/Time when the [radio button (yes)] or [radio button (no)] is
selected

If no is selected, then the Date and Time Field is auto populated with the
current Date/Time (as with the yes selection) and the Resolved [Date/Time
Field] is shaded gray and null

 

[Arvin Meyer MVP]

Sub chk1_AfterUpdate()
If Me.chk1 = -1 Then
Me.[Exceptions Handling] = Now()
Else
Me.[Exceptions Handling] = Now()
Me.[Exceptions Resolved] = ""
Me.[Exceptions Resolved].Enabled = False
End If
End Sub

Sub chk2_AfterUpdate()
Me.[Exceptions Resolved] = Now()
End Sub

 

[Beeyen]

It works great!

Thanks

Sub chk1_AfterUpdate()
If Me.chk1 = -1 Then
Me.[Exceptions Handling] = Now()
Else
Me.[Exceptions Handling] = Now()
Me.[Exceptions Resolved] = ""
Me.[Exceptions Resolved].Enabled = False
End If
End Sub

Sub chk2_AfterUpdate()
Me.[Exceptions Resolved] = Now()
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Good Day,

I am using Access 2003 and continue to be challenged by this, and thought
I
would describe my dilemma a bit differently. If you could share your
thoughts
or possible solution to the questions below that would be great. Thanks
in
advance.

The following information is in a subform;

Exceptions Handling [Date/Time Field] [radio button (yes)] [radio button
(no)]
Exceptions Resolved [Date/Time Field] [radio button (yes)] [radio button
(no)]

If yes is selected, then the Date and Time Field is auto populated with
the
current Date/Time and the Resolved [Date/Time Field] is auto populated
with
the current Date/Time when the [radio button (yes)] or [radio button (no)]
is
selected

If no is selected, then the Date and Time Field is auto populated with the
current Date/Time (as with the yes selection) and the Resolved [Date/Time
Field] is shaded gray and null