Error Msg stLinkCriteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sash - 30 Mar 2005 21:23 GMT

I have a form ACCT where the user enters and account number and clicks
button that has code to 1) verify if information is in table A and 2) Open
the detailed form using link criteria to open for only that ACCT#. It was
working until I added a subquery to the query that drives the Detailed form.
I'm now getting an error

"The specified field acct could refer to more than one table listed in the
from clause of your SQL statement"

I can however run the query that drives the detailed form. I know this one
is hard to understand without seeing. Just hoped someone might read and be
able to give me some direction. My deadline is Friday and when I think I've
got it....I hit another wall.

Reply to this Message

Graham Mandeno - 30 Mar 2005 23:02 GMT

Hi Sash

You must have included the ACCT field from both tables in your query.
Either delete one of them, or qualify the field by adding the table name to
the criteria string:

stlinkCriteria = "[my table].[ACCT]=" & something

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

>I have a form ACCT where the user enters and account number and clicks
> button that has code to 1) verify if information is in table A and 2) Open
[quoted text clipped - 13 lines]
> I've
> got it....I hit another wall.

Reply to this Message