OnChange and OnNotInList

[Joe]

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.

 

[Mr B]

Personally, I would use the AfterUpdate event to refresh data after the
selection is made.

The value of the combo box is not really correct until after the user has
made their selection.