OnChange and OnNotInList

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just looking for other ideas on how people handle this.

I have multiple combo boxes that are based on a query and the client
wants to be able to just type in new values, so I am limiting to the list
and am using OnNotInList to kick off the data entry behind the new
value. The issue is that if they select from an item in the list I had
been using OnChange to refresh the subform that displayed data. Of
course OnChange interprets every keystroke as a change, so I have to
evaluate each keystroke (which is a pain).

Is there a better way to initiate a refresh of the data? How do you
experts handle this situation?

Thanks for the thoughts.
.

Relevant Pages

  • RE: OnChange and OnNotInList
    ... I would use the AfterUpdate event to refresh data after the ... made their selection. ... course OnChange interprets every keystroke as a change, ... evaluate each keystroke. ...
    (microsoft.public.access.formscoding)
  • Trying to refresh IE page, cause screensaver interrupt
    ... window and sends the keystroke 'F5' to refresh the page. ... cannot find a working version of a delay timer that will insert a 10- ...
    (microsoft.public.vstudio.general)
  • Trying to refresh IE page, cause screensaver interrupt with VB.net
    ... window and sends the keystroke 'F5' to refresh the page. ... cannot find a working version of a delay timer that will insert a 10- ...
    (microsoft.public.vb.general.discussion)
  • Re: On Form Refresh?
    ... If you set the form's KeyPreview property to Yes, you could trap the keystroke in the form's KeyDown event. ... I dont necesarily need the form's recordset to refresh but there are a few ...
    (microsoft.public.access.formscoding)