Simple SQL returning an error?

[baadams]

Here's the SQL.

sqlstmt = "SELECT * FROM T_WORK_ORDER WHERE WKOR_LOAD_DATE >= [forms]![frm_Switchboard]![LastEmailDate]"

Set rst = CurrentDb.OpenRecordset(sqlstmt)

I get a 3061 error "Too few arguments Expected 1" on the Set rst? The form is open and there is a value in the field LastEmailDate

I get the same error when passing the query in the set statement. That also uses that field as a parameter. That's why I switched it to SQL. The SQL works fine in the MS Access query builder but doesn't work in this situation.

 

[boblarson]

You have to put the reference outside of the quotes and use octothorpes (#) for dates:

sqlstmt = "SELECT * FROM T_WORK_ORDER WHERE WKOR_LOAD_DATE >=#" & [forms]![frm_Switchboard]![LastEmailDate] & "#"

 

[baadams]

I'll try that now and post an update. Thanks.

 

[baadams]

Bob, Thanks that did the trick!