text field Visible based on a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cboordertype that I use for my orders, what I want to do is that
when "Program" is selected from the cbo box, a field designname become
visible, else visibility = false.

Any ideas?

Thanks,

Bro;ok
 
I am assuming that "field" designname is a text box.
In the AfterUpdate event of cboordertype:
IF me.cboordertype = "Program" then
me.designname.visible = true
END IF

You will also have to do me.designname.visible = false when you are done wit
the current record. Where you put it depends on what else goes on in your
form. It should be the last thing before you go to a new record, or the
first thing you do when you get a new record.
 
Brook,

Put code like this on the After Update event of the combobox...
Me.designname.Visible = Me.cboordertype = "Program"
 
Thanks for the replies,

What would I set the initial value for the desginname text box for ?
Visible yes or no?

Brook
 
Brook,

Not sure. Not visible initially probably. In a sense it doesn't
matter. Give it a try and see which suits your purpose best.
 
Back
Top