Making a list box visible based on another control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BigNasty - 18 Apr 2006 23:45 GMT

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?

Reply to this Message

fredg - 19 Apr 2006 01:09 GMT

> 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
[quoted text clipped - 3 lines]
> How can I code this so that the text box doenst appear when the
> coniditon is not met?

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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

BigNasty - 19 Apr 2006 01:14 GMT

Thanks Fred!

Reply to this Message