refrence to table

[Tom]

Hello there

I want to write a code as follows for the table :

CheckCriteria = Forms![ENTER METRIC TO INPUT METRIC]!
[ENTER METRIC TO INPUT METRIC Subform].Form!IM_Name

The above code have a checkcriteria function which
refrences to the form.

Now if i want to refrence a table how can i do that.
I would appreciate if somebody could help me on that.

Thank you.

 

[John Vinson]

Hello there

I want to write a code as follows for the table :

CheckCriteria = Forms![ENTER METRIC TO INPUT METRIC]!
[ENTER METRIC TO INPUT METRIC Subform].Form!IM_Name

The above code have a checkcriteria function which
refrences to the form.

Now if i want to refrence a table how can i do that.
I would appreciate if somebody could help me on that.

What about a Table do you want to "reference"? You can use DLookUp to
look up a selected field from a record in a table using criteria; you
can open a Recordset based on a table; it depends on what you're
trying to accomplish.

But there is nothing analogous to the Forms! reference type - as
you've probably discovered, you can't use Tables!tablename!fieldname
in VBA.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps