Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Items to list from an array

Status
Not open for further replies.

kameta

IS-IT--Management
Jan 17, 2001
16
0
0
KE
Is it possible to add items from an array to a list box control. In VB We use addtolist which seems to be not in Access. What is up with Bill gates?
 
Yes you can. The data source for a 'values' list box is a string with ";" semicolons between.

You could do a

Dim str1 as string

str1 = me.list0.recordsource
str1 = str1 & ";" & ar(1)

then me.list0.recordsource = str1
me.list0.requery


Rollie E
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top