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.