>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? 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.
- It must go directly into the RowSource property.
- The property must hold the statement as a string, e.g.,
this.RowSource = "SELECT * FROM mytable"
.
What is your select statement? It's probably that or you didn't store the select in RowSource as a string.
Insanity: Doing the same thing over and over and expecting different results.