General information
Category:
Forms & Form designer
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only