Hi, I need to be able to do the following (it's a documents control database):
On a form, the user selects from a list box whether they want a form, procedure, directive, etc.
The results are displayed in another list box (i.e. all forms, or all procedures);
When the user clicks on a record in the second listbox, the rest of its records are displayed. Kind of a three-tiered approach.
It's all based on a query to begin with.
Is this possible? Can you display list box results in a list box?
Or should I be writing a command button "where condition" - if this is the case, what is the condition?
Document type = form, procedure, directive, etc.
Thanks in advance
On a form, the user selects from a list box whether they want a form, procedure, directive, etc.
The results are displayed in another list box (i.e. all forms, or all procedures);
When the user clicks on a record in the second listbox, the rest of its records are displayed. Kind of a three-tiered approach.
It's all based on a query to begin with.
Is this possible? Can you display list box results in a list box?
Or should I be writing a command button "where condition" - if this is the case, what is the condition?
Document type = form, procedure, directive, etc.
Thanks in advance
