Listbox "List" property

F

FR

I programmed a system in Excel VBA (before user had Access) and populated a
listbox from an array using the List() property. Trying to do it in Access
2007 VBA but the listbox seems to have lost its List property. What happened?
What can I use instead?

Thanks for any help.
 
N

ND Pard

You might put something similar to the following into your forms "On Open"
event:

Private Sub Form_Open(Cancel As Integer)
Me.LBx_A.RowSourceType = "Value List"
Me.LBx_A.RowSource = "Cogs;Bolts;Nuts"
End Sub

Good Luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top