Select Multiple Value

[Dhamdard]

Dear Access Experts,

In a form, I want to set values in 'Station' variable based on value selected in 'BroadcastType' variable. If the type of value is 'nationwide' in broadcastType variable, then I want the 'station' variable to automatically select all values from the combo box list that it has. The 'station' variable is a combo box where multiple value is allowed.

Appreciate your usual help.

Dad

 

[vbaInet]

Can you explain what you mean by Station variable?? Are you talking about value?

 

[Dhamdard]

Sorry for the confusion. Station is a field that has a drop down list of radio/tv stations. Values for station field can be one or more from the drop down list. This again means that station field is a combo box.

 

[vbaInet]

I think what you're talking about is Cascading combo box. Search the form for that term, it's been discussed many times.