And I guess the question, here, would be why the OP is using a ValueList as the Row Source Type (as the use of AddItem suggests) if, as is apparent from the use of
rs!EventDate
instead of the Table or Query that holds the data?
At any rate, using literal strings for the AddItem, the syntax would be
Me.ListboxName.AddItem "FirstColumnItem;SecondColumnItem"
Linq ;0)>
with a semi-colon between the column items.
John_G is correct, of course, you can use a ValueList instead of a Table/Query. Generally, you should only use a ValueList if the is very little possibility that the choices will ever, ever, ever change! Doing so, with a ValueList requires going back into Design Mode to make the modification...whereas with a Table/Query based Combobox/Listbox, you can simply add data to the Table/Query.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007