Access Set DAO Recordset

[m2techinc]

I've written a function which uses a DAO Recordset. The following statement sets the recordset:
Set rs = db.OpenRecordset("qryLast24Months")

My dilemma is that when my query has a criteria set as follows: [forms]![frmModels].[ModelNum], the function will not work due to a syntax error. However, if I set the criteria to an actual modelnum such as 7300, the function works just fine.

Any help or ideas are appreciated.

[Rabbit]

I've written a function which uses a DAO Recordset. The following statement sets the recordset:
Set rs = db.OpenRecordset("qryLast24Months")

My dilemma is that when my query has a criteria set as follows: [forms]![frmModels].[ModelNum], the function will not work due to a syntax error. However, if I set the criteria to an actual modelnum such as 7300, the function works just fine.

Any help or ideas are appreciated.

Try changing the . to a !

[ADezii]

I've written a function which uses a DAO Recordset. The following statement sets the recordset:
Set rs = db.OpenRecordset("qryLast24Months")

My dilemma is that when my query has a criteria set as follows: [forms]![frmModels].[ModelNum], the function will not work due to a syntax error. However, if I set the criteria to an actual modelnum such as 7300, the function works just fine.

Any help or ideas are appreciated.

This question may seem a little silly, but is frmModels Open?

[m2techinc]

This question may seem a little silly, but is frmModels Open?

The form is open...I also tried changing the . to a ! but it still throws a run-time error "Item not found in this collection".

[Rabbit]

That usually means you've misspelled something.

What's db set to?

[m2techinc]

That usually means you've misspelled something.

What's db set to?

db is set as follows:
Set db = CurrentDb()

[Rabbit]

Does the query work outside of code? What's the SQL for the query?

[m2techinc]

Does the query work outside of code? What's the SQL for the query?

The query does work outside the code so I decided to try to put the query SQL statement in my function instead and was able to get it to work that way. Tks.

[Rabbit]

The query does work outside the code so I decided to try to put the query SQL statement in my function instead and was able to get it to work that way. Tks.

Well, glad you got it working. Good luck.

[JConsulting]

I've written a function which uses a DAO Recordset. The following statement sets the recordset:
Set rs = db.OpenRecordset("qryLast24Months")

My dilemma is that when my query has a criteria set as follows: [forms]![frmModels].[ModelNum], the function will not work due to a syntax error. However, if I set the criteria to an actual modelnum such as 7300, the function works just fine.

Any help or ideas are appreciated.

Jet's pretty strange about recordsets. Sometimes you can get away with using just the query name, others you can't. there is a workaround

Set rs = db.OpenRecordset("select * from qryLast24Months;")

Should do.
J