I have a database with a drop down box that lists all of the contacts in the database. When I select someone in that drop down box it goes directly to their record.
What I want to do is be able to display different criteria in the drop down box based on some criteria. So one criterion might be everyone, another criterion might be only people with a certain product.
How would I do this?
I guess I would like something like, one drop down box selects the criteria (show all clients, or show all clients with a certain product), then another drop down box is based on that one which displays that which was select in the first drop down. Then the results in the form would display based on the second drop down.
What I want to do is be able to display different criteria in the drop down box based on some criteria. So one criterion might be everyone, another criterion might be only people with a certain product.
How would I do this?
I guess I would like something like, one drop down box selects the criteria (show all clients, or show all clients with a certain product), then another drop down box is based on that one which displays that which was select in the first drop down. Then the results in the form would display based on the second drop down.
Last edited: