refrence a 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.

 

[Ken Snell [MVP]]

Reference a table? In what way? Do you want to get a value from a table? If
yes, use the DLookup function to obtain a value from a record in a
table...see how to use it in Help file.