How to manually populate a Listbox?

[Guest]

I have a 4-column listbox that I want to MANUALLY place values into via a SQL
lookup. So I issue the SQL command, and if I have 4 rows returned, I end up
with four rows in the Listbox. But I use VB to issue the query and populate
the Listbox.

How may I do that?

Thanks!

 

[Guest]

Additional information:

My listbox has three columns. I want to populate each column with a field
from the record selected.

 

[Douglas J Steele]

That's not the way list boxes are supposed to work...

If you're determined, though, you can write a function that can be used as
the RowSourceType for the listbox.

http://msdn.microsoft.com/library/en-us/vbaac11/html/acproRowSourceTypeFunctionParameters
gives the details for this function (don't worry if you're not using Access
2003: that function works in all versions of Access)

 

[John Vinson]

I have a 4-column listbox that I want to MANUALLY place values into via a SQL
lookup. So I issue the SQL command, and if I have 4 rows returned, I end up
with four rows in the Listbox. But I use VB to issue the query and populate
the Listbox.

How may I do that?

Thanks!

Why go all the way around the barn?

Just set the listbox's RowSource property to the SQL string. You end
up with exactly the same result, unless I'm completely
misunderstanding your meaning.

John W. Vinson[MVP]

 

[Guest]

Thanks! I never thought of doing it that way (d'oh!)