Display a field from a linked table

[sherrydeng]

I'm working on a MS Access database, there's one table linked from a ODBC database.

In the ACESS table, I defined 2 fields,A and B, each of them maps the field in the ODBC table. A field C in the ODBC database can return a unique value with both the info. A and B.

We want the C value can be automatically show up after we input the A. B value in a MS ACCESS form.


It sounds very easy. and if we use asp it should be easy. However, I just get stucked here. Whether I can do it in MS ACCESS.

Can anyone help?

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sherrydeng]

Thanks PHV;

Where can I use this DLookup function.
in MS Access, only the forms can have VB code rite?