Combo Boxes

[camidon]

I have a form that has three combo boxes on it. The lists are built using a SELECT DISTINCT query on a field in one of my tables. Each one of the combo boxes uses the same query.

The problem is that when I make an addition to one of the lists, the new entry doesn't show up in the other lists until I close the form and re-open it.

What is the best way to force each one of those combo boxes to requery when one of the loses focus?

Thanks in advance,

Chris

 

[mp9]

After adding to one of the lists, use

Requery

in a VBA event to update the datasource of the other combos.

http://www22.brinkster.com/accessory/