I am working with Access 2000 (DAO)
On a form I have a field named ?caPK? (Country ID) and a list named ?SelList” that displays States (or whatever) by Country. There are to many records within SelList to effectively ?scroll? to my desired setting (6K +).
On the same form I have a combo box named ?QuikFind? that correctly indexes focus to the first ?caPK? within a set (states within a country) and loads saPK (First State, Territory, Province, or whatever) with the value needed to reset the focus within SelList. What code should I enter in the ?QuikFind? combo box?s After Update event to synchronize my forms list box so it’s focus will change to the same state record? Thanks
QuickFind locates the Country first record ONLY and does not contain a state (?saPK?) value used to sort the list box. Once QuikFind executes however a populated saPK is available through the same form (Me) to reset focus within SelList. SelList.Requery just finds the first country and does not considersaPK as a filter.
