How to make an object visible when a value is chosen from a cmb

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

Guest

Hi, I'm working on a form at the moment with a combo box that has a variety
of choices (value list), one of them being "Archived". When this particular
one is chosen, I'd like a text box to appear (say, txtBoxnumber). And when
the combo box does not have this value, then txtboxnumber is invisible.
Further, I'd also want the form to remember what the visible status was for
txtboxnumber on each record, so that when I scroll from one record to
another, txtboxnumber is either visible when the combo box = archived and
invisible when combo box = NOT archived. I've done this similar thing
before but not with combo boxes, so any help would be much appreciated,
Cheers,

- Matt
 
Hi, I'm working on a form at the moment with a combo box that has a variety
of choices (value list), one of them being "Archived". When this particular
one is chosen, I'd like a text box to appear (say, txtBoxnumber). And when
the combo box does not have this value, then txtboxnumber is invisible.
Further, I'd also want the form to remember what the visible status was for
txtboxnumber on each record, so that when I scroll from one record to
another, txtboxnumber is either visible when the combo box = archived and
invisible when combo box = NOT archived. I've done this similar thing
before but not with combo boxes, so any help would be much appreciated,
Cheers,

- Matt
Click to expand...

In the Combo Box AfterUpdate event and in the Form's Current event:

Me![txtBoxNumber].Visible = Me!ComboName = "Archived"

The above assumes the combo box is bound to a field in a table, and
the combo box's bound column is text datatype.
 
Back
Top