Different tables on one report/form

[Nick J]

Hi,

I currently have a report set up on tblDownload but in the report I want to
fill a text box with information from a field in another table.

Thanks.

--

Kind Regards...

Customer Services Team
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading

[Lisa]

Nick J writes: Hi, I currently have a report set up on tblDownload but
in the report I want to fill a text box with information from a field
in another table.

Response - Nick, it sounds like you may need to create a query that
includes both tables and build your report off that query. I know it
is a simple answer, but it was the first thing that came to me! Hope
it helps!

[fredg]

On Thu, 21 Apr 2005 23:43:23 GMT, Nick J wrote:

Hi,

I currently have a report set up on tblDownload but in the report I want to
fill a text box with information from a field in another table.

Thanks.

If you can create a query using both fields and make the query the
reports record source, then you will have access to the second table.

If you cannot combine both tables, and you need a reference to just
one field in one record in the second table, then you can use a
DLookUp in an unbound control to find the value:

=DLookUp("[FieldName]","TableName","[SomeField] = " & [SomeCriteria])

Look up DLookUp in VBA Help, as well as
Where clause + Restrict Data to a subset of records
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.