By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Different tables on one report/form

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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!

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.