Openrecordset with date criteria

[Eric]

I'm trying to open the following recordset with date criteria but I'm getting
an error message: (syntax error, mssing operator)

Set rstin = dbs.OpenRecordset("SELECT * FROM detailslinerental WHERE
TelephoneNumber = '" & f!TelephoneNumber & "' And [ItemStartDate] => #" &
rstsplit!startdate & "#")

Does anyone see what I'm doing wrong here? TIA

 

[Allen Browne]

Break it down into separate lines:
Dim strSql As String
strSql = "SELECT ...
Debug.Print strSql
Set rstin = dbs.OpenRecorset(strsql)

When it fails press Ctrl+G to open the Immediate window.
You'll probably see what's wrong with the SQL statement.
If not, copy it, and paste it into a new query (in SQL view.)

It may be that one of the values you are pasting in is Null, so the string
is malformed.