How programatically load a listbox ?

[Guest]

How can I programaticaly load entries into a listbox

Or, is it better to create a temporary table and use that as a rowsource?

 

[Douglas J. Steele]

What version of Access?

In Access 2002 and Access 2003, listboxes have an AddItem method that lets
you load entries.

Prior to that, a temporary table is the easiest, although it is possible to
write a call-back function that can be used to populate a listbox.

Check
http://msdn.microsoft.com/archive/e...ngcomboboxesandlistboxesinmicrosoftaccess.asp

(Apologies for that awful URL: hopefully it'll stay intact in this posting!)

 

[fredg]

How can I programaticaly load entries into a listbox?

Using some event:
ListBoxName.RowSource = "Some SQL Statement Here;"

Or, is it better to create a temporary table and use that as a rowsource?

Probably not! But who can respond to this with any certainty?
You haven't given any indication of what the rowsource is supposed to
be, or anything else about what you are trying to do.

 

[MikeB]

How can I programaticaly load entries into a listbox?

Or, is it better to create a temporary table and use that as a rowsource?

Dim TextValueToAdd as String

Ac2K:

ListBox.RowSource = ListBox.RowSource & ";" & TextValueToAdd

Ac2002> :

List1.AddItem TextValueToAdd