List Box Synchronization using Access - TechRepublic
General discussion
December 23, 2001 at 02:35 AM
donq

List Box Synchronization using Access

by donq . Updated 24 years, 6 months ago

I am working with Access 2000 (DAO)

On a form I have a field named ?saPK? and a list named ?SelList. 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 ?saPK? within a set (states within a country) and loads saPK 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 focus to the same record the main form moves to?

QuickFind locates the Country first record ONLY and does not contain a ?saPK? value used to drive the list box. Once QuikFind executes however a populated saPK is availablethrough the same form (Me) to reset focus within SelList.

This discussion is locked

All Comments