Populating a List Box in VB

[guamlet]

I have three variables (var1, var2, var3) that contain a string. These variables are established when the form opens. I want to use them to populate a list box that already exists but is empty. So basically, I want to use VB to add items to an existing list box. Any suggestions?

 

[Russell Hauf]

You can put them in a semi-colon separated list, then set the row source to that list. Oh, and set the Row Source Type to Value List. These aren't the max values from before, are they?

 

[guamlet]

Yep, they are! That's why I was using variables...these variables don't exist in a table or anything...they're just VB variables....I thought I could do a lst.AddItem but VB isn't recognizing that command.

 

[Russell Hauf]

I thought that you used DMax in a query...you can set the list box's Row Source to that query. Then, when a new record is added, just do a .Refresh on that list box in your code.

If you're having trouble, show me how you are getting the 3 variables and I'll see if I can be of further help.

-rh

 

[guamlet]

Cool! I didn't realize that I could use that text as a query. I was just using it in VBA code...problem solved thanks to you!!!!!