W
Walter
I'm trying to adapt Allen Brown's flexible search form dynamic criteria
builder to set the rowsource of a listbox. I've put the code in the Click
event of the command button. The strWhere is building correctly. My
question is where do I put the Listbox.RowSource = "Select field1, field2,
from table1" and how do I include the strWhere to filter the results?
Everything I've tried so far has failed.
builder to set the rowsource of a listbox. I've put the code in the Click
event of the command button. The strWhere is building correctly. My
question is where do I put the Listbox.RowSource = "Select field1, field2,
from table1" and how do I include the strWhere to filter the results?
Everything I've tried so far has failed.