Hi - am new to the forum and appreciate your time.
I have a legacy VB form I am updating at work which has four different drop down items that display times (the RowSource for each drop-down is simply a column of times in increments of five minutes). I attached an image.
In order to prevent errors, I want to create a macro that accomplishes the following:
After the 1st drop-down is set (maybe after it leaves focus or the user uses TAB), I would like the remaining three drop-downs to automatically default/populate to the same value as was selected in the 1st. When the second is set, I would like the remaining two to default to the second. And when the third is set, I would like the fourth to default to the third.
For our purposes, each dropdown box should always be equal to or greater than the preceding box, and I would like to prevent errors by auto-updating the fields as the user moves through them.
I am not sure how to capture and 'lost-focus' event or update the displayed value of the drop-down.
Any ideas ?
Thanks again
Bookmarks