Selecting list to populate combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
We have a fleet of 400 buses which consists of 3 different types of vehicle
that are distinguishable by their fleet numbers. I have created a userform
for data entry and the fleet numbers are input via a combo box. What I would
like is that having entered a route number in the form the combo box would
only show the fleet numbers available for that route. Is it possible to vary
the RowSource property using different lists depending on the route selected.
Thanx for your help.
 
Back
Top