Specify table/query in Code

[rae]

I am trying to reference data in a table/query that is not being referenced
by my form in Access. How do I code for the other table/query. If I simply
type it in like in regular Access it gives me a "Can't find this field" which
it is not just a field, it is a whole other table/query.

[ArthurWood]

Rae,
What do you mean by "If I simply type it in like in regular Access "?
Where are you trying to type it in?

Arthur Wood


"rae" <reaton@ssm.org> wrote:
>
>I am trying to reference data in a table/query that is not being referenced
>by my form in Access. How do I code for the other table/query. If I simply
>type it in like in regular Access it gives me a "Can't find this field"
which
>it is not just a field, it is a whole other table/query.

[Ron Phillips]

In Access, you might just use the name of the table or query in th
forms designer. If you had a table called "tblTable", in Access you
can just type in "tblTable" - the equivilent in SQL for this is
"Select * from tblTable".

Hope this helps,
Ron

On 14 Dec 2000 10:22:39 -0800, "rae" <reaton@ssm.org> wrote:
>
>I am trying to reference data in a table/query that is not being referenced
>by my form in Access. How do I code for the other table/query. If I simply
>type it in like in regular Access it gives me a "Can't find this field" which
>it is not just a field, it is a whole other table/query.