G
Guest
Im looking to see if its possible to create a drop down menu in a query. I
already have it so it asks the user a question. I actually have 2 problems. I
am searching according to 3 criteria right now. The present year (needed
because it calculates a value), the company (which i want to create a drop
down menu for so as to reduce spelling mistakes) and the Facility (which is
where the job is needed to be done). I need all 3 to make a list for the job
to be done. The second problem is that i want to be able to search for
multiple facilities. Right now it asks me [What facility?] but i can only
enter one. The company may have a lot of different facilities so i wanted to
be able to search for more then one. I know how to do it in the design view,
by entering the different names in the OR row, but i wanted to be able to
have access ask me. Any help would be much appreciated. Thanks
already have it so it asks the user a question. I actually have 2 problems. I
am searching according to 3 criteria right now. The present year (needed
because it calculates a value), the company (which i want to create a drop
down menu for so as to reduce spelling mistakes) and the Facility (which is
where the job is needed to be done). I need all 3 to make a list for the job
to be done. The second problem is that i want to be able to search for
multiple facilities. Right now it asks me [What facility?] but i can only
enter one. The company may have a lot of different facilities so i wanted to
be able to search for more then one. I know how to do it in the design view,
by entering the different names in the OR row, but i wanted to be able to
have access ask me. Any help would be much appreciated. Thanks