IF else vb after combo box selection

[stumanchu]

On a form, I have a 2 combo boxes. One lists EquipmentName, the other Procedure rooms. 2 pieces of equipment are each stationary in its own procedure room. I want to be able to auto fill the procedure room only when either piece of equipment is chosen. For example, if equipment "Fluoro Rm #2" is selected, only fill procedure room "Fluoro room #2", if equipment "Fluoro Rm #4 is selected, only fill procedure room "Fluoro room #4", if any other piece of equipment is chosen, then the other procedure rooms are available to select.

2 tables:
EquipmentTbl & ProcedureRoomTbl

I'm sure VB is invovled - perhaps On Exit event on equipment name?

Thank you for any suggestions

 

[Pretty1996]

Hi,

if I understand correctly you're trying to base 1 combo box on another right?

 

[Pretty1996]

Well if that is your query then try this

http://office.microsoft.com/en-us/access-help/basing-one-combo-box-on-another-HA001173058.aspx

Its very good and goes through step by step.

Regards

 

[stumanchu]

Hi, thank you for replying. I found a solution: I could disable one combo box if a particular selection is made in the other combo box & vice versa. It works, but may not be the best solution. I will read up on the link you sent. I appreciate your help.

 

[SydneyGeek]

You shouldn't need to have multiple combos for this; two would suffice, unless I misunderstood.
Basically, the first combo is selected and that restricts the choices from the second. Make another selection in #1 and #2 updates with the new options.
See if this helps you.

Denis

 

[stumanchu]

Thanks SydneyGeek - will get myself educated