I have a combobox class that I have been working on to do Quicken style data-entry. With help from here on the UT I have gotten it to just about where I want it.

Now in implementing it, I have one particular rowsource table that is baffling me.

I have an example with two comboboxes based upon the same class. The only difference is the query (method mquery) which populates the array which is the rowsource. In one, which uses a customer table, the first time the combo gets focus it works as expected, the list drops down. Subsequently, if I move back to that combo, the list doesn't drop down.

The identical (except for the SELECT source, which is inventory) combo works reliably and as expected.

I have tried looking at the data in the customer table to see if there is any corruption, exported and reimported SDF, SELECT DISTINCT, etc. and still no joy.

If anybody thinks they might be able to help with this, I would really appreciate it. I have a small ZIP file available with the example form, the two comoboboxes, and the necessary data.

TIA for any help.

Andrew