Making a list box visible based on another control

  • Thread starter Thread starter BigNasty
  • Start date Start date
B

BigNasty

I have a text field on my access DB form that i would like to appear if
a user selects a particular item from a combo box. I have completed
this part of the code. However, when user selects another record on the
form where the condition isnt true the combo box still appears.

How can I code this so that the text box doenst appear when the
coniditon is not met?
 
I have a text field on my access DB form that i would like to appear if
a user selects a particular item from a combo box. I have completed
this part of the code. However, when user selects another record on the
form where the condition isnt true the combo box still appears.

How can I code this so that the text box doenst appear when the
coniditon is not met?
Click to expand...

I would assume you coded the AfterUpdate event of the Combo Box
something like:
Me![SomeControl].Visible = Me![ComboName] = 'Jones'"

Place the same code in the Form's Current event.
 
Back
Top