Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View_On Function?

Status
Not open for further replies.

kermitforney

Technical User
Mar 15, 2005
374
US
Is there a way to control a control's appearance based on another conrtol?

Say for instance I have 'number' and 'alpha' in a combo box. When you select alpha another combo box appears on the same form. But that second combo box will only display if you select alpha from the first combo box. Other wise it will not show on the form at all.

In other words it could be described a control's visibility on another control.
 
Have you tried using the first combobox's after_update event, or onclick event. Evaluate the comboboxes text and act upon it accordingly

private sub combobox1_afterupdate()
me.comboboxalpha.visible = comboxbox1.text = "Alpha"
me.comboboxnum.visible = comboxbox1.text = "Numeric"
end sub

Of course you will have to change the names to your stuff?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top