>I have a simple form with a spinner where a user can change the year to display data in a grid for. The grid has a parameterized view (LogFile.Year = ?lnYear) where lnYear is derived from the value of the spinner. When the user spins the spinner, at what point would you Requery() the view to refresh the data in the grid?
>
>I have thought about the InteractiveChange but that could fire off the requery too often and degrade performance. I thought about LostFocus but then nothing is refreshed or requeried until the control loses focus. The user wonders why nothing is happening. I thought about a timer to start when InterActiveChange fires. If a certain amount of time lapses, then fire requery. This adds more complication than may be necessary.
>
>Just thought I would get some opinions.
>
>TIA.
Mark,
This one is not a view approach and therefore may not be so smart but what about collecting existing years to a true cursor and relating to table. Then you would keep a combo with rowsource fields from that cursor. Relation catches fast as to my experience (used even on 286s in old days).
Cetin