Hi
No worries simply base the lookup (on the form) on a query. Bring both
tables into the query design gride and link them there. Use this a thr base
for your (form) lookup field.
I take it you have a lookup field with a primary field (number) in the first
column and some text in the next – it doesn’t matter which table it comes
from as long as the data you want is actually there.
I think you will have something like this
Col 1 = 123, 124, 125, etc - Number
Col 2 = abc, abd, abe, etc - Text
If this is the case then you could bring in the lookup field into your
report and set the visibility to No. Then create an unbound text box and use
this to refer to your hidden lookup field. This is the field that is shown
in the detail section of the report.
Lookup field [ABC] thats the name of the field
Text box =[ABC].column(1) that’s the control source
You may already know this but not sure, so - The reason for the 1 and not 2
(as you may expect) is that the column count starts from 0. So the 1st
column = 0, 2nd = 1, 3rd = 2, etc
--
Wayne
Manchester, England.
Enjoy whatever it is you do
emattison said:
Thanks for the effort, however,
The column that is referenced is the lookup column and is classified as a
number. The column referenced is a different table all together. I'm not
sure how to link the report without loosing the data associations for the
table being used. I tried the entry below without success.
Wayne-I-M said:
You can set the source of the report field as the lookup but refer to the
column of the lookup (hope that makes sence)
e.g.
=[ABC].column(1)
--
Wayne
Manchester, England.
Enjoy whatever it is you do
emattison said:
I have a report based on a complicated table which includes lookup data that
has text. The field in question (being a lookup field) is classified as a
"number" rather than "text", which can't be changed. In either the form or
the table, the information comes up as text. The problem is that in report
mode, Access refuses to show the text because it is classified as a number!
The result is important information is not showing up correctly. What can I
do?
