Listbox "List" property

  • Thread starter Thread starter FR
  • Start date Start date
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.
 
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.
 
Back
Top