matthew230
Board Regular
- Joined
- Jan 2, 2006
- Messages
- 152
Hi,
I'm interested in seeing if there is a technique to achieve the following:
I am building a reporting tool that queries a seperate database, what I need to do is somehow get a form with associated checkboxes to apply a filter, where the number of options are unknown and recreated each time.
For example, say a certain field had 3 seperate statuses, A, B or C and the string was returning results that matched those, I want a form with an associated Checkbox of all possible statuses. I then can construct the query.
The problem is that for one section I may have A, B, or C and another may include D and E aswell, therefore I need the form to be dynamic as the number of options is lkely to vary often. I can list the options to a worksheet to draw this data easily enough, I'm do not know how to create a dynamic form.
So any ideas or solutions greatly appreciated.
I'm interested in seeing if there is a technique to achieve the following:
I am building a reporting tool that queries a seperate database, what I need to do is somehow get a form with associated checkboxes to apply a filter, where the number of options are unknown and recreated each time.
For example, say a certain field had 3 seperate statuses, A, B or C and the string was returning results that matched those, I want a form with an associated Checkbox of all possible statuses. I then can construct the query.
The problem is that for one section I may have A, B, or C and another may include D and E aswell, therefore I need the form to be dynamic as the number of options is lkely to vary often. I can list the options to a worksheet to draw this data easily enough, I'm do not know how to create a dynamic form.
So any ideas or solutions greatly appreciated.