Easy combo box question.

[Salient]

Have a combo box at the top of a form with a whole lot of items loaded to it from an access file. What I want to happen is the program user selects an item from the combo box, which then leads to a record read and population of other objects on the form.

So far so good, can get that to happen. My problem is determining which event to use. The best result thus far is to put code into LostFocus, but then it requires the end user to click somewhere else in the form for the combobox code to fire. Is there a better event that will auto populate the form controls without the user needing to click away from the combobox

 

[WayneRyan]

Salient,

That's a nice question.

Access has the "IntelliSense" that will let you "fill out" a combo without
typing in the entire string. BUT it doesn't fire any event.

Even with an "unbound" combo, when you select an item from the list, you'll
fire the BeforeUpdate event. Which is what I think you want.

hth,
Wayne

 

[Salient]

Wayne code is in vb6, access is our backend database. Requirement is to allow the software client to switch databases to either oracle or unidata in the future.

Not seeing a "BeforeUpdate" method in those available.

Thanks for the reply.