cmbEvent.Clear
SqlTxt = "SELECT * from EventMstr order by event_dt desc "
Set rstEventMstr = dbsFruit.OpenRecordset(SqlTxt, dbOpenDynaset)
If rstEventMstr.EOF Then
MsgBox "Event must be added before inventory "
rstEventMstr.Close
Exit Sub
End If
Do While Not rstEventMstr.EOF
With rstEventMstr
cmbEvent.AddItem !Event_Dt & " " & !event_desc
.MoveNext
End With
Loop
rstEventMstr.Close
cmbEvent.Text = cmbEvent.List(0)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.