I have a form with 3 drop downs and 1 Browse. The dropdowns build the filter for the Browse. The 1st dropdown resets the 2nd, the 2nd resets the 3rd and the 3rd resets the Browse.
In some cases the 3rd dropdown only has 1 selection. I can easily check the data after the 2nd dropdown is accepted to determine the number of records in the 3rd dropdown. If there is just 1 record, how do I reset the Browse in code and skip the 3rd dropdown? I assume this would go after the 2nd dropdown is accepted.
Second, if the 3rd dropdown has but 1 record, is it possible to hide it?
Still learning ....
Thank you,
Rich