I have a form that has 2 drop down lists. One is for a list of items with English units of measure, other is Metic.
When user selects a value in English drop down, the metric list disappears correctly.
I save the form and the data is saved.
When I open the form back up, the data from the english drop down is displayed. However, the Metric drop down list is now visible.
Is there an event that i should be using to hide the second drop down if the first was selected in a previous session?
thank you for any help.
to start make them both invisible
run an initial check to see if any data is saved
if data saved then display the relevant list box
if no saved data, display both lists.