Hello everyone,
I recently had a request from users to be able to build a custom query thru a Form interface that they can use and check off the options they want.
Not sure even where to start (besides building the form and adding checkboxes).
I was trying to find the best way to do this and im think maybe querydef? But im not sure how to even start.
Thankfully, its only 1 table - [Employee] and a collection of fields - [Status], [StatusDate], [Address], [Phone], [IDNo], , etc.
How can I create a subform/query that will change dynamically based on the corresponding boxes checked, without including, ALL the fields in the table?
Thank you for your help
I recently had a request from users to be able to build a custom query thru a Form interface that they can use and check off the options they want.
Not sure even where to start (besides building the form and adding checkboxes).
I was trying to find the best way to do this and im think maybe querydef? But im not sure how to even start.
Thankfully, its only 1 table - [Employee] and a collection of fields - [Status], [StatusDate], [Address], [Phone], [IDNo], , etc.
How can I create a subform/query that will change dynamically based on the corresponding boxes checked, without including, ALL the fields in the table?
Thank you for your help