Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>Dear alls,
>
>I would like to use SQL statement on the combo box. When I type the SQL command with 'into cursor temp', it haven't any response when click it. But using the command without 'into cursor temp', the query result displayed on the screen and it can show up the data when I clicked it. What's the problem? Can I hidden the query result or using 'into cursor temp'? Thanks for any reply and suggestion!
>
>Thanks a lot! Wish you all the best!
>
>Best Regards
>
>Justy Chow
What are you putting into the .RowSource property?
Just to mention simply another manner in which to load a combo box, I usually use .Requery to execute a SQL statement and then load the combo using .AddItem.
This allows me to close the cursor once the combo is loaded. The drawback here is that by loading values rather than a cursor, view or table, one must force a requery to load any new values if that is a concern.
Steve
Précédent
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