Problem with simple where statement using dates

[fogal]

I get the error msg no current record with this, but works from design view of query and sql is similar to sql view in query?????

sql1 = "SELECT * FROM tblAdvPublDates WHERE (((tblAdvPublDates.LastAppear)>=#" & [Forms]![frmReports]![PublDate] & "#))"

Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset(sql1, dbOpenDynaset, dbSeeChanges)

MsgBox rst(0)

 

[JeremyNYC]

I don't know what rst(0) would return. Try
msgbox rst!NameOfOneOfYourFields

Also, you say similar...what are the differences? I test this by putting a break point on the set rst line and in the immediate window typing
?sql1

which will return the exact sql string you're passing. Take a look at whether or not that has records.

Also, do you have a date in that control that would actually return some records in the query?

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.