Pop up text box

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a form in which I would like a text box to open only when OTHER is
selected from a previous list box.

Is there a code for this?
 
Create your text box on your form that you want to pop up. Double
click it to see the Properties. Click on format and change the Visible
Setting to No. Now in the After Update Event for your list box, put

If Me.MyListBoxName = "Other" then
Me.MyTextBoxName.Visible = true
Else
Me.MyTextBoxName.Visible = False
End if

Change MyListBoxName and MyTextBoxName to the names that you have used.

Hope that helps!
 
It worked!
However, when I close the form and reopen it, the Text Box is not visible
when Other is selected. How can I keep it visible once Other is selected?
 
Ok, now I made it a Continuous Form since there could be multiple reasons
beside other. Any time I select Other the text box opens for all the entries.
Can you control a Continuous Form in this way?

Jeff said:
Put the If statement in the On Current event of the form.
It worked!
However, when I close the form and reopen it, the Text Box is not visible
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
Back
Top