I am a very elementary level access user.
I am trying to set up a database at work and am having some issues with Querying via a form and having it displayed on a sub form.
I have started off with a large job file containing numerous fields pertaining to each job. I then took several of the fields and have made them into drop down lists using separate tables.
I have built the database with a main data entry form (form1) which puts the results into the main data table (jobfile) which contains all of the fields. I then made several of the fields into drop down lists.
I plan need to be able to search the database via those drop down fields...
my goal is to create a new form which will allow me to search through the database based on the 3 the drop down lists (jobstatus_lookup) (site_lookup) (silo_lookup). I want to be able to select any number of the drop down fields in any combination and search and then have the full jobfile information for the criteria matching results returned on a sub form.
Could you recomend the appropriate code or put me in the right direction. (I had been using combo boxes before to do this, but I was only able to search via one field)
I appriciate that this question may be to long or tasking and that I may be too lost for anyone to assit me, but thank you for your time and consideration to anyone who has looked it over.
Sean
I am trying to set up a database at work and am having some issues with Querying via a form and having it displayed on a sub form.
I have started off with a large job file containing numerous fields pertaining to each job. I then took several of the fields and have made them into drop down lists using separate tables.
I have built the database with a main data entry form (form1) which puts the results into the main data table (jobfile) which contains all of the fields. I then made several of the fields into drop down lists.
I plan need to be able to search the database via those drop down fields...
my goal is to create a new form which will allow me to search through the database based on the 3 the drop down lists (jobstatus_lookup) (site_lookup) (silo_lookup). I want to be able to select any number of the drop down fields in any combination and search and then have the full jobfile information for the criteria matching results returned on a sub form.
Could you recomend the appropriate code or put me in the right direction. (I had been using combo boxes before to do this, but I was only able to search via one field)
I appriciate that this question may be to long or tasking and that I may be too lost for anyone to assit me, but thank you for your time and consideration to anyone who has looked it over.
Sean
