Visible field on a continuous form

[Abby N]

Hi all. I’m having a problem with questionnaire I’m building. Technically I think this is a problem with a form. But I’m posting it here because I’ve got a feeling the solution will lie in code. The questionnaire is built as a form containing a question with a continuous subform listing a number of subquestions. For example:

What foods do you like? (check all that apply)
Italian
Chinese
American
Indian
Other (specify)

In the above example I have check boxes to record the users responses. However, I’d also like to include a field for the users to enter text for the “Other” response. So, my question is this. Can I make a field visible for a single record on a continuous form? If so, how? If not, does anyone have an alternate idea? Thank you in advance for your assistance.

~Abby

P.S.
I've tried this code. The result is the field is not visible until I goto the "Other" record. At that point it becomes visible in all records.

Private Sub Form_Current()
If InStr(1, Me.txtSubQuestion, "specify") > 0 Then
Me.txtResponseNote.Visible = True
Else
Me.txtResponseNote.Visible = False
End If
End Sub


[This message has been edited by Abby N (edited 01-18-2001).]

 

[Richie]

Hi Abby you coud try a different approach and cheat a little, set the backround colour of "specify" to transparent, remove border ,
in the on click of other: Me.Specify.SetFocus
set tab stop for specify to none , SpecifyEnter: If Me.Other = 0 Then
Me.SomewhereElse.Set Focus
End If
Just in case someone clicks in by accident.
You could refine it even more and in the after update of Other :If Me.Other = -1 Then
Me.Specify.SetFocus
Else
Me.Specify =""
End If
HTH

 

[Abby N]

That should do it. I'm reminded of something my father used to say, "If it's a stupid trick and it works, then it's not a stupid trick." Thanks Richie! =)

~Abby