I had considered the "overlay" technique, but I hadn't tried the MouseDown(). This looks like a bug to me. I just wanted to make sure I wasn't missing some finer point of combobox usage that would make this work in a straightforward manner. Thanks for the specifics on the workarounds!
>I got it to work the way you want using MouseDown instead:
> PROCEDURE MouseDown
> LPARAMETERS nButton, nShift, nXCoord, nYCoord
> This.Requery()
> ENDPROC
>This could become a performance problem depending on the size of the table you are querying because this will fire anytime the user clicks anywhere on the combo, not just the dropdown button. I could not make it work using the DropDown event.
>
>You could dummy this up by overlaying a textbox over the display part of the combo to do your search with. When the user click the drop down button, you could do the requery from the lostfocus of the textbox. Once you select a value from the dropdown list, you could set the Value of the text box to the display value of the dropdown.
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data