>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement