diplay combobox list in date format
Private Sub cboCoveredBondSubType_AfterUpdate()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=C:\CovBonds\CB.mdb"
Dim strRange As String
If NewProgramAdded <> True Then
strRange = "SELECT DISTINCT [cboReportingDate] FROM dbo_tblCoveredBonds Where [cboExistingCoveredBondProgram] = '" & cboExistingCoveredBondProgram & "' AND [cboCoveredBondType] = '" & cboCoveredBondType & "' AND [cboCoveredBondSubType] = '" & cboCoveredBondSubType & "' ORDER BY [cboReportingDate] DESC;"
rst.Open strRange, _
cnn, adOpenStatic
rst.MoveFirst
With Me.cboReportingDate
.Clear
Do
.AddItem VBA.Format(rst![cboReportingDate], "dd/mm/yyyy")
rst.MoveNext
Loop Until rst.EOF
End With
Set rst = Nothing
Set cnn = Nothing
End If