Dynamically showing a third option button

[MKMurphy]

I am creating a form with Yes and No option buttons. However, some questions
don't apply, and I need to display an option button NA for those questions.
My underlying table is set up as such: PKQuestionID, QuestionText,
Response(this is the only field the user changes), and IsResponseRequired. I
have optNA.Visible=False. My form is Continuous View. I want to read the
value of IsResponseRequired and if =0(meaning the user doesn't have to answer
the question) then make optNA visible so they can choose it.

Question is, where do I place the code? Not in Form.Load or Detail.OnPaint.

thanks,
MKM

 

[Ken Snell MVP]

Use Form_Current event.

 

[MKMurphy]

no go. is it b/c I'm in Continuous View?

Use Form_Current event.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Ken Snell MVP]

"No go" means what? In a Continuous Forms view, the record that you're on
will dictate whether the button is visible -- ON ALL RECORDS seen. When you
switch to a record where the button is to be invisible, all the records will
not show the option button. If you switch to a record where the button is to
be visible, all the records will show the option button.

The code for the Current event would be something like this:

Private Sub Form_Current()
Me.optNA.Visible = (Me.IsResponseRequired <> 0)
End Sub
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/