Search Criteria Form in MS Access 2010
Posted on 2012-08-30
My application is an Access 2010 64-bit database that I have created to track different processes in our project. As part of the database, I created a Search Criteria form. On this form, I have three radio buttons to allow the users to select what form they want to search on. So it is Option 1 = Cases; Option 2 = Requests; and Option 3 = Data Objects
The second unbound text boxes allows the users to fill in either or all of the criteria for Case #, Request ID #, Production Name and/or Data Load ID.
Case # = AA-00004 (two letters, hyphen and 5 digits)
Request # = 88888 (all numbers)
Production Name = String
Data Load ID = 333 (three digits all numbers)
There are two date fields that I want to search only on the Data Objects Form so I would like to allow the users to enter date ranges for the Date Received and Date Available. The user should only be able allowed to enter the dates if they choose the Data Objects radio button. When the search button has been clicked on then open up the records in the form that they picked.
I am very lost in writing code for this form. Thank you for any assistance that anyone can give me. I am trying to finish this database by Tuesday.