Split contents of an Access field into separate variables in VBA-CodePudding

I have an Access table containing a field with multiple dates (ex: 11/22/2022, 11/23/2022, 11/24/2022) that needs to be split into usable variables. The field could contain 1 to 40 dates, it's unknown at any given time.

I have been unable to find any examples of this being done, any links or ideas anyone might know of?

CodePudding user response：

On your form, create a combo- or listbox. Name it, say, EventDate.

Set its RowSourceType property to ValueList.

Insert code like this in the OnCurrent event of the form:

Private Sub Form_Current()

    Me!EventDate.RowSource = Nz(Me!YourMultiDateField.Value)

End Sub

This will list the dates with the option to select one.