I'm doing something wrong with OpenRecordset???

[MLH]

When the following runs, I get error saying "Jet can't find input
table/query qdfMarkedAddnlOwnerRecs" The error occurs in
line #150 Sub cmdSaveVehicleRec_Click() frmVehicleEntryForm.

120 Set MyDB = CurrentDb ' Set MyDB =
OpenDatabase("Northwind.mdb") is alternate syntax.
140 With MyDB
149 Set qdfMarkedAddnlOwnerRecs =
..CreateQueryDef("NewQueryDef", "Select * From tblAddnlOwners Where
[AOActionMark]=True;")
150 Set rstMarkedAddnlOwners =
..OpenRecordset("qdfMarkedAddnlOwnerRecs", dbOpenSnapshot)
230 With rstMarkedAddnlOwners
240 .MoveFirst
250 Do Until rstMarkedAddnlOwners.EOF

What exactly have I done wrong?

[kaniest]

MLH schreef:

When the following runs, I get error saying "Jet can't find input
table/query qdfMarkedAddnlOwnerRecs" The error occurs in
line #150 Sub cmdSaveVehicleRec_Click() frmVehicleEntryForm.

120 Set MyDB = CurrentDb ' Set MyDB =
OpenDatabase("Northwind.mdb") is alternate syntax.
140 With MyDB
149 Set qdfMarkedAddnlOwnerRecs =
.CreateQueryDef("NewQueryDef", "Select * From tblAddnlOwners Where
[AOActionMark]=True;")
150 Set rstMarkedAddnlOwners =
.OpenRecordset("qdfMarkedAddnlOwnerRecs", dbOpenSnapshot)
230 With rstMarkedAddnlOwners
240 .MoveFirst
250 Do Until rstMarkedAddnlOwners.EOF

What exactly have I done wrong?

For starters, sticking to a single thread might help.

What happens when you use clean syntax like:

With CurrentDb
With .CreateQueryDef("", "Select * From tblAddnlOwners Where
[AOActionMark]=True;")
With .OpenRecordset(dbOpenSnapshot)
yada yada

Also, consider Alberts remark if the actual code really is that simple.