I'm being asked if i can make it so that when a combo box is opened, the choice is already at a particular record
when a user is editing a specific record, they often need to refer to another that is typically only a few records away (but not always). the combo box gets them to the info they need. consequently, when they open the combo list, and the focus is at the first record, they find themselves having to scroll through the (occasionally longer
-ish) list until they get to the range of records that would the choice would be in (but sometimes, the record they want may be early in the list, or sometimes towards the end ...usually not)
the question is:
can i make it so that when the drop-down list opens, a specific record (in this case with a value equal to a field on the current form, is selected?
with thnx in advance,
mark