made changes to table and modified the assigning
still getting error
Dim startdate2 As String
Dim enddate2 As String
startdate2 = Me.start_date
enddate2 = Me.end_date
Dim SQL As String
SQL = "SELECT FROM frmproject WHERE [RepairDate] between #" & startdate2 & "# and #" & enddate2 &...
I have form with two date text boxes. One is start date and the other is end date. I want to query a table and only pull records that the date field is between the start date and end date.
my code I am working on is:
Dim startdate2 As String
Dim enddate2 As String
Me.start_date = startdate2...