I have 17 more command boxes in a single form showing different route names. When user is clicking a particular command button, the query parameter should be auto filled with some fixed data. I am in need to auto fill the Route_ID query parameter for every command button once it has been clicked or opened. There are 17 different routes and when user chooses the particular route by clicking the command button, the query's parameter behind that will be auto fill with that Route_ID.
I need the VBA code for that. Thank you.