Text Box visible only when selecting specific record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dwaynesworld - 31 Jan 2007 17:46 GMT

I have a form in which a user will select a specifc course from a combo box.
What I am trying to accomplish is that when the user selects a specific item
from the combo box (MISC-Project), a text box will appear asking for the name
of that specifc project (Misc_Project_Name) and remain hidden when other
entries are selected. I know that this will be an After_Update event for the
combo box but I am stuck as to where I go next.... Thanks!!!

Reply to this Message

Douglas J. Steele - 31 Jan 2007 17:52 GMT

In the AfterUpdate event of the combo box, put logic to check what was
selected, and toggle the visibility of the text box based on that:

Private Sub MyCombo_AfterUpdate()

Me!Misc_Project_Name.Visible = (Me!MyCombo = "MISC-Project")

End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a form in which a user will select a specifc course from a combo
>box.
[quoted text clipped - 6 lines]
> the
> combo box but I am stuck as to where I go next.... Thanks!!!

Reply to this Message

dwaynesworld - 31 Jan 2007 18:18 GMT

Thanks for the info...works just fine!!!

> In the AfterUpdate event of the combo box, put logic to check what was
> selected, and toggle the visibility of the text box based on that:
[quoted text clipped - 15 lines]
> > the
> > combo box but I am stuck as to where I go next.... Thanks!!!

Reply to this Message