I am migrating an Access2k app to SQL server. The old app was feeding a list box via VBA in the style :
query = "SELECT * FROM table"
the WHERE clause is dynamicaly constructed by a function within VBA so that on different events the listbox's rowsource is
me.listbox.rowsource = query & createwhereclause()
The question is how can I change this in order to have the query executed on the server ?
I would be able to do the same using recordsets by I could not get the rowsource to accept the recordset as valid input.
Thanks for the help,