Hi there. I am working on a bit of database development and I would like to have a form where I can fill out some textboxes and comboboxes to query my table and return the records that match ALL criteria.
I have a found a really similar example at
http://allenbrowne.com/ser-62code.html
I would like to modify this type of form.
The difference is that I cannot have all of the records on display as I will need to restrict access to some users eventually (a question for a later date).
So I would like to program an action button that will search using all criteria and display all of the records in a separate subform for the purpose of reviewing and editing incident reports.
I am very weak in VBA but am learning fast. Please help!
Also if there is more information I can provide to clarify my question please let me know.
-Z
I have a found a really similar example at
http://allenbrowne.com/ser-62code.html
I would like to modify this type of form.
The difference is that I cannot have all of the records on display as I will need to restrict access to some users eventually (a question for a later date).
So I would like to program an action button that will search using all criteria and display all of the records in a separate subform for the purpose of reviewing and editing incident reports.
I am very weak in VBA but am learning fast. Please help!
Also if there is more information I can provide to clarify my question please let me know.
-Z
