Filling listbox from VBA

[gazsharpe101]

Hi, I am using MS Access 2003 and I wish to simply fill a listbox from VBA. I have read that you can just do listname.additem .... but I do not have the .additem option after inputting the list name and was wondering why this is? I believe it may just be a reference/component thing but I've no idea really :-)

Thanks,
Gareth.

[ADezii]

Hi, I am using MS Access 2003 and I wish to simply fill a listbox from VBA. I have read that you can just do listname.additem .... but I do not have the .additem option after inputting the list name and was wondering why this is? I believe it may just be a reference/component thing but I've no idea really :-)

Thanks,
Gareth.

You need no External References to use the AddItem Method in Access 2003, perhaps your syntax is incorrect. The correct usage is as follows, assuming your List Box is named List1:

Dim intCounter As Integer
 
'critical step
Me![List1].RowSourceType = "Value List"
 
For intCounter = 1 To 500
  Me![List1].AddItem "Item Number: " & intCounter
Next
 

Sample List Box contents:

Item Number: 1
Item Number: 2
Item Number: 3
Item Number: 4
Item Number: 5
Item Number: 6
Item Number: 7
Item Number: 8
Item Number: 9
Item Number: 10
Item Number: 11
Item Number: 12
Item Number: 13
Item Number: 14
Item Number: 15
Item Number: 16
Item Number: 17
Item Number: 18
Item Number: 19
Item Number: 20
...
Item Number: 500

[gazsharpe101]

Hi, thanks for your reply.

I have just tried that and I don't get the .rowsourcetype thing appearing as an option either :-(

I can't understand why this is the case, any help is much appreciated.

Thanks.
Gareth.

[ADezii]

Hi, thanks for your reply.

I have just tried that and I don't get the .rowsourcetype thing appearing as an option either :-(

I can't understand why this is the case, any help is much appreciated.

Thanks.
Gareth.

In any Code Module Window, make sure the following Option is checked (Yes):

1. In a Code Module Window
2. Tools
3. Options
4. Editor
5. Auto List Members (check)
6. The Auto List Members Options controls whether or not the logical options for the completion of a Statement in VBA occurs.
7. Good Luck and get back to me on this one.

[gazsharpe101]

Hi, thanks for your reply. I have managed to get what I needed, the reason the .additem wasn't available because it was on a report and apparently it is only available on forms etc but not reports.

[ADezii]

Hi, thanks for your reply. I have managed to get what I needed, the reason the .additem wasn't available because it was on a report and apparently it is only available on forms etc but not reports.

the reason the .additem wasn't available because it was on a report and apparently it is only available on forms etc but not reports.

You are correctamundo - you solved your own problem.