I have a table that contains [Route_Num] and [Cust_Num] for our delivery drivers. I would like to use this table in a form, with a drop-down combo box for each field. The [Route_Num] field would be the first to be selected. I would like to have the [Cust_Num] drop-down list filtered to be limited to only those serviced by [Route_Num].
I have tried to send the value selected for [Route_Num] to a query to return the shortened list, and use this for the [Cust_Num] drop-down, but Access did not like my method. Any suggestions?