Recordset results as SQL

Shep

Shep
Local time
Yesterday, 23:37
Joined
Dec 5, 2000
Messages
364
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?
 
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*
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom