By richvle - Thu Mar 19, 2020 7:23 pm
- Thu Mar 19, 2020 7:23 pm
#827754
I have 2 dropdown controls on the same form.
{EDIT - I had the THEN portion reversed}
Approver1 and d Approver2. Both are dynamically populated with SQL.
If Approver1 has 0 records, then hide Approver1 and show Approver2.
If Approver 1 has > 0 records, then show Approver1 and hide Approver2.
Any ideas?
{EDIT - I had the THEN portion reversed}
Approver1 and d Approver2. Both are dynamically populated with SQL.
If Approver1 has 0 records, then hide Approver1 and show Approver2.
If Approver 1 has > 0 records, then show Approver1 and hide Approver2.
Any ideas?
Last edited by richvle on Fri Mar 20, 2020 2:08 pm, edited 1 time in total.