HI,
I been trying to figure out how to have three combo boxes update two text boxes with no luck. I'm lookin for suggestions/help
I have a table that has fields ID (PK); MAJCOM; baseid; base, unit, state, and country. The majcom, base, state and country fields may have duplicates in each table record.
I have combo box1 querying the table and displaying just the majcoms (use the select distinct to eliminate duplicates). After update event procedure selects all the bases that have the selected majcom identified to them and populates combo box 2 with this data
combo box 2 then takes the selected base, identifies the units associated with that base then populates combo box 3 using after update event procedure.
combo box 3 currently displays the units assigned to the base.
All three boxes work great to this point. Problem I can't figure out is how to get the state or Country that is associated with that base/unit to be populated in a corresponding text box.
any ideas?
I been trying to figure out how to have three combo boxes update two text boxes with no luck. I'm lookin for suggestions/help
I have a table that has fields ID (PK); MAJCOM; baseid; base, unit, state, and country. The majcom, base, state and country fields may have duplicates in each table record.
I have combo box1 querying the table and displaying just the majcoms (use the select distinct to eliminate duplicates). After update event procedure selects all the bases that have the selected majcom identified to them and populates combo box 2 with this data
combo box 2 then takes the selected base, identifies the units associated with that base then populates combo box 3 using after update event procedure.
combo box 3 currently displays the units assigned to the base.
All three boxes work great to this point. Problem I can't figure out is how to get the state or Country that is associated with that base/unit to be populated in a corresponding text box.
any ideas?