I am creating a database of pavement conditions.
I am trying to create a form for a user to be able to search the database based on 2 criteria, Route Number and Town Name. I have the form set up as 2 linked combo boxes, so when you select what route it gives you the possible towns. I want to be able to launch a seperate form, displaying details based on whats entered in these two combo boxes. As of now I can only create a command button to launch the form based on one or the other. How can I encorperate both of the combo boxes into the command button?
I am trying to create a form for a user to be able to search the database based on 2 criteria, Route Number and Town Name. I have the form set up as 2 linked combo boxes, so when you select what route it gives you the possible towns. I want to be able to launch a seperate form, displaying details based on whats entered in these two combo boxes. As of now I can only create a command button to launch the form based on one or the other. How can I encorperate both of the combo boxes into the command button?
Comment