Display in a report

  • Thread starter Thread starter Peggy
  • Start date Start date
P

Peggy

I have a combo box in a form/subform. The contents are
text. It stores the contents in tblHistory. When I create
a report based on this table, or if I make a query based
on this table, then base the report on the query, it
displays auto number not the text.

I have made combo boxes on forms and they store as the
text.
 
The combo box probably has 2 columns, the visible one being the text the
user would understand and a hidden, bound column that sends the ID
associated with the text to the table. This is normal functioning. To get
what you want in the report, add this second table (the one supplying the
Row Source of the combo box) to the query feeding the report. Join it to the
current table on this ID field. Choose the text field from this new table to
show in the query and subsequently, in the report.

To create the Join, if it doesn't auto create, drag the ID field from one
table to the associated ID field in the other table.
 
-----Original Message-----
That seemed pretty simple, however, I am now so screwed
Click to expand...
up I don't know what I'm doing. I get this message 'The
Microsoft Jet database engine cannot find a record in the
table, Service, with key matching field "ServiceID" Now I
can't even get my subform to work.
What information should I pass on so you can help me?



The combo box probably has 2 columns, the visible one
being the text the
 
Peggy,

If what you did made thing worse, then undo it and see if you can get back
where you were. I'll need a little more detail about what you are actually
doing.

1) What is the Record Source for the main form and its subform
2) What is the Row Source for the combo box.
3) What is the Control Source for the combo box.
4) What is the Bound Column for the combo box.
5) What is the Record Source for the report.
6) What fields are the main and sub forms linked on.
 
Back
Top