Recordset results as SQL

[Shep]

I have a feeling I should know this...a little thick-headed today.

How do you populate a listbox with the results of a recordset?

 

[shacket]

Me.lstBoxName.RowSource = "SQL Statement"

 

[Shep]

Well, I am trying very hard to follow Pat's advice. Therefore, I must base all my Recordsets on saved queries (with OWNERACCESS OPTION).

If I use an SQL statement as a listbox's rowsource, my users cannot read the data, due to security restrictions.

By the way Pat, this is becoming quite an interesting exercise. Thanks for the challenge. *grin*

 

[RichMorrison]

you wrote
<<
Well, I am trying very hard to follow Pat's advice. Therefore, I must base all my Recordsets on saved queries (with OWNERACCESS OPTION).
>>

That's right !

So the syntax is:
Me.lstBoxName.RowSource = "SavedQueryName"

BTW, you don't need code for this. Just set RowSource in the list box properties window.

RichM

 

[Shep]

I have solved this for now by creating a saved query that produces the same record set as the recordset I was trying to use, and using this as the rowsource for the listbox.

Thank you, shacket.

Shep