I have a Memory form with 3 drop downs and a Browse control. Dropdown 1 filters dropdown2. Both of these are used to filter dropdown 3. The last dropdown file has about 1,500 records. The filtering causes only a few to be displayed at any one time. However, when I put some trace code in the validate routine for dopdown 3 I find that it is executed once for every record in the file, not for the ones displayed or just the one selected.
This happens twice, when dropdown 2 is selected (since it resets dropdown 3) and then when a selection is made from dropdown 3. So, just to make my selections. before it ever goes to the main file, it is reading 3,000 records.
I can't use a lookup since the idea of the dropdown is that the user doesn't know what to enter.
Is this the way this is supposed to work? Is there a better way?