>>A client wants a combo in a toolbar. The data in the combo must be filtered. I used a RowSourceType of 3, and created a SELECT statement. It works as long as I don't use a WHERE clause. If I do that, I get no records at all. If I use the same SELECT in a test form, the command window, or in a test program, it works fine.
>>
>>Steve
>
>Steve, could you post the code you're using? I've used WHERE clauses in combos with no problems....
>
>Barbara

Barbara,

Mystery solved. The value of _screen.oApp.iPrimaryKey was getting changed after the Init and the SELECT of the combo, but before the toolbar displayed. The solution was to requery the combo immediately after the value was changed.

And to think I spent half a day at that...

* cSteve