Hello forum,

I'm trying to generate an interactive UserForm in which a User can set a schedule, view the schedule, and edit the schedule, all natively within said UserForm.

I've gotten the ListBox to populate other Textboxes within the UserForm from a backend database, but am having issues updating DatePicker objects with the backend database date values. Looking at the Locals window, I can confirm that the value being recorded is the correct date, but the DatePicker object still displays the default date of 'Today'.

Any thoughts?

Private Sub lstSystem_dblClick(ByVal Cancel As MSForms.ReturnBoolean)

Dim i As Integer

On Error Resume Next

i = Me.lstSystem.ListIndex 'Find the selected list item
Me.txtKeyID.Value = Me.lstSystem.Column(0, i)
Me.txtSysName.Value = Me.lstSystem.Column(1, i)
Me.txtSysAcronym.Value = Me.lstSystem.Column(2, i)
.............................
Me.dtTestComplete.Value = Me.lstSystem.Column(39, i)

On Error GoTo 0

End Sub
dtTestComplete.Value is the DatePicker object in question that will not seem to update.

Any help would be much appreciated!