No Current Record Message

[Niranjan]

I have a query in Access 2002 database that used to work fine. But now
it comes up with "3021 - No Current Record" message.

The query is based on 2 other queries. Those 2 queries run fine
individually and have common records. Several fields are linked
between these queries. One of these "linked" field was added recently.
I am not sure if that caused this problem. I tried running the query
after deleting the link to the newly created field and still I got the
same error.

Any suggestions are welcome. I need to fix this soon - the deadline is
very near.

[Allen Browne]

I'm guessing that:
a) You used an outer join between the 2 queries, and
b) The table on the outer side of the join has a yes/no field.

If so, see:
Outer join queries fail on Yes/No fields
at:
http://allenbrowne.com/bug-14.html

There is another bug in A2002 (one service pack only) that gives this bug,
but that's in the AfterDelConfirm event of a form, which doesn't sound like
where you are.

It can also be caused by a damaged index (which is fixed by a
compact/repair.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Niranjan" <nh****@gmail.comwrote in message
news:11**********************@v29g2000prd.googlegr oups.com...

>I have a query in Access 2002 database that used to work fine. But now
it comes up with "3021 - No Current Record" message.

The query is based on 2 other queries. Those 2 queries run fine
individually and have common records. Several fields are linked
between these queries. One of these "linked" field was added recently.
I am not sure if that caused this problem. I tried running the query
after deleting the link to the newly created field and still I got the
same error.

Any suggestions are welcome. I need to fix this soon - the deadline is
very near.