G
gramps
Apart from a simple flat file database this is my first venture into Access.
I have produced a form that logs radio calls from 10 bus routes. Each route
has a unique series of operating numbers which pinpoints each journey in the
schedule. Each route exclusively operates 1 of 3 types of bus, (mini, double
decker or articulated bus) and each bus has a fleet number which identifies
the bus as well as the type of bus. Each bus also has a radio that has a
unique radio id.
I have a combo box populated with the route numbers and what I would like is
once the route has been selected is for a second combo box to be populated
with that routes series of operating numbers and a third combo box to be
populated with the fleet numbers of the buses that can run on that route.
Once the appropriate vehicle has been selected it would automatically enter
its radio id into another text box.
Any help as to how do this would be great.
I have produced a form that logs radio calls from 10 bus routes. Each route
has a unique series of operating numbers which pinpoints each journey in the
schedule. Each route exclusively operates 1 of 3 types of bus, (mini, double
decker or articulated bus) and each bus has a fleet number which identifies
the bus as well as the type of bus. Each bus also has a radio that has a
unique radio id.
I have a combo box populated with the route numbers and what I would like is
once the route has been selected is for a second combo box to be populated
with that routes series of operating numbers and a third combo box to be
populated with the fleet numbers of the buses that can run on that route.
Once the appropriate vehicle has been selected it would automatically enter
its radio id into another text box.
Any help as to how do this would be great.