Value list appears in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am a new Access user & have a question.

In a table I have a field defined with a value list to choose from. This goes well except when I generate a report for this table all the values print out in the report in reverse video. I think this is an easy one, but I can't seem to get around it. Thank you for helping a newbie...
 
It sounds like you have placed a combo box on your report?

Instead, use a query as the source for your report.
In the query, include your main table and also this lookup table.
If some of the main records are blank in the lookup field, double-click the
line joining the 2 tables in the top of the query design window, and choose
the option:
All records from "MainTable", and any matches from ...

Choose this query as the RecordSource of your report, and you can now use
the field from the lookup table in the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

GA said:
Hello,

I am a new Access user & have a question.

In a table I have a field defined with a value list to choose from. This
Click to expand...
goes well except when I generate a report for this table all the values
print out in the report in reverse video. I think this is an easy one, but I
can't seem to get around it. Thank you for helping a newbie...
 
Hello Allen,

Thank you for the info. I did the steps you suggested,
but I still get the list of all the defined values from
my pull down menu in the table. Any other suggestions ?

Thank you.
 
Hello Allen,

Thank you for the info. I did the steps you suggested,
but now i get the value of the fields that I have matched
from both tables. Ex: Both tables have an empid and
that's how i connect them. Any other suggestions ?

Thank you.
 
I'm really not clear what you want here.

You have 2 tables, joined on a field named "empid". In the query you created
is there are line joining empid in one table to empid in the other? If so,
the query will return the matches.

For example, if the drop-down list shows the skills that workers have such
as:
accountant
programmer
telemarketer
typist
and John Yates is a programmer, the output of the query should show
John Yates programmer
and then move on to the next person on the next row of the query.
 
Back
Top