Problem with OpenRecordSet in Access!

[frag]

Hi again!

I am stumped again with this VBA-shoot.

Here is what i'd like to do:

1. I put a SQL-statment in a String
strAreas = "SELECT * FROM

WHERE

.[field]
= 'something' AND

.[datefield] = #14/12/00#

2. I want to open a RecordSet
Set rstAreaFields = CurrentDb.OpenRecordset(strAreas)

And here is my problem. I get a "Run-time error '3061'" which says: "Too few parameters. Expected 1."

Has anybody a clue what to do?

thanx!

frag

 

[frag]

it's me again (oh no!!)

just forget this thread! i did a typical rookie-mistake with the sql-string in my code!

sorry

frag