>>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

Hi Barbara,

(I like the picture you chose.)

I have tested the SELECT in a combo in a test form, too, and it works fine. I suspect the property of oApp...

select cField1, cField2 ;
from MyTable ;
where lngForeignKey = _screen.oApp.iPrimaryKey ;
into cursor MyCurs

_screen.oApp.iPrimaryKey is set before this. If I set up a text box, it displays properly.

I'm going to try a few more things momentarily.

* cSteve