General information
Category:
Coding, syntax & commands
>>>>>>>>>>>>>>>>>>>>>>>
When I have RowSource Type = 3 SQL Statement does that mean that I have to put the SQL SELECT statement directly in the RowSource property of the listbox?
Or can I put the SQL SELECT statement somewhere else and assign it a name instead and use that name in the RowSource property of the listbox?
>>>>>>>>>>>>
You can declare variable like mysql="sele ....." and in the listbox init/refresh method use code like: this.RecordSource=mysql.
>>>>>>>>>
I put the CURSOR name from my SQL SELECT in the RowSource property, but I get an error "unrecognized command verb." What options do I have if I want to just stick a name in the RowSource instead of the whole SQL SELECT statement since depending upon the user's choices different SQL SELECT statement might end up populating the listbox drop-down list? Thanks for helping me understand this.
>>>>>>>>>>>>>>>>>>>>>>>>>>>
You can not use alias name in this case.
Hope this help.
Best Wishes
Previous
Next
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