Error Msg stLinkCriteria

[Guest]

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.

 

[Graham Mandeno]

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