List box issue in Access 97

[Thakur8385]

You would be aware the List.additem is not available in MS Access 97.
Could you please suggest alternative way to add items to a list box runtime.

 

[Allen Browne]

If the RowSourceType is Table/query, see:
http://allenbrowne.com/ser-27.html

If it's a Value List, you can append the new value to the RowSource, e.g. if
it currently contain:
1;2;3
you could add 4 like this:
With Me.Combo1
.RowSource = .RowSource & ";4"
End With

 

[Douglas J. Steele]

Just be aware that Access 97 had a much lower limit on the length of string
that could be used for the RowSource property than in subsequent versions,
so there's a limit as to how many items you can add.