Making Combo's Appear

[Pete]

I have a series of Combo's in a form all hidden except the first one.
Depending on what is chosen in the first combo how do I make the
others appear.

Pete

 

[Howard Brody]

In the AfterUpdate event for the main ComboBox, based on the selection, show/enable/requery the appropriate others. This can be done with VBA code or with conditional macros

In one of my databases, I track data by Division, Region, Regional Office and Employee. Each Employee is assigned to an Office, each Office is in a specific Region and each Region in a specific Division. I have four ComboBoxes, oine for each category.

In the AfterUpdate event for cboDivision, the source for cboRegion is changed from "SELECT ... FROM tblRegions" to "SELECT ... FROM tblRegions WHERE [tblRegions].[Division]='" & [cboDivision] & "'" and then cboRegions is requeried. Same this is done for the other Combos

Hope this helps

Howard Brod


----- Pete wrote: ----

I have a series of Combo's in a form all hidden except the first one
Depending on what is chosen in the first combo how do I make th
others appear

Pet

 

[Pete]

I have a series of Combo's in a form all hidden except the first one.
Depending on what is chosen in the first combo how do I make the
others appear.

Pete

That's a bit too much for me, I'm a newbie. Can you give me an easier
example to follow.

My first combo is called LossType

the first item in the combo is Planned Maintenance, if I select this
item, I want the "Comments" text box to appear.

thanks

Pete