I am trying to use the following code to open a form and select only the date that was selected in lstDate.
Private Sub cmdEdit_Click()
On Error GoTo cmdEdit_Err
Expire = lstDate
[Forms]![CCaulk].RecordSource = "SELECT Caulk.Expires FROM Caulk WHERE Caulk.Expires =" & Expire