For the between,
Private Sub cmdActivityLogDaily_Click()
Dim strCaption As String
strCaption = "Today's Activity Log"
DoCmd.OpenForm "ActivityLogQReport", acFormDS, , "CallDate=" & BETWEEN Format(Me.txtDate, "\#mm/dd/yyyy\#") and Format(Me.txtDate, "\#mm/dd/yyyy\#"), , , strCaption
End Sub...