Need to display a field from another table in a form.

  • Thread starter Thread starter Robert Johnson
  • Start date Start date
R

Robert Johnson

HI all. I have a form based on a query from table1 and I also need to
display a field from table2 which is not in the query. This field is just
for info only. How do I do this as table2 is not related to table1 so I
can't add it to the table1 query.

Clear as mud??

Robert
 
HI all. I have a form based on a query from table1 and I also need to
display a field from table2 which is not in the query. This field is just
for info only. How do I do this as table2 is not related to table1 so I
can't add it to the table1 query.

Clear as mud??
Click to expand...

Somewhat opaque, actually. Suppose Table2 has 32,455 records? Which
one do you want to see? How do you know?

You can probably use DLookUp() to display the field value - but you
need to know what it is you are looking up!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
opps sorry. Table2 has only 1 record. It holds info regarding the company
and I want to display the value of one field in the table on my form.
HTH,

Robert
 
Back
Top