Changing what prints on a report

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

Guest

I have a parent table named "Learn" with 2 fields; an autonumber field(pk)
and a text field. I have a field called "Lrn" in a child table named "App"
that looks up the fields in table "Learn" and Binds the autonumber field.
When I print reports the autonumber prints. I would like to continue to
store the autonumber in the child table but would like the information from
the text field in the parent table to print on my report. How can this be
accomplished?
 
The first problem is you can have only one record source for a report. If
you are using a sub report, then it can have it's own record source. It
works just like forms and subforms. So, If you have just a report with no
subs and you want to have parent and child records in the report, create a
query that joins the two tables and use the query as the record source for
the report.
 
Open the report in design view. Right-click on the Lrn textbox that
currently shows the Autonumber. Choose Change To->Combo Box. Then, in
the Properties window for the combo box, click the Data tab. Set the
following properties:

Row Source Type: Table/Query
Row Source: Learn
Bound Column: 1

Now click the Format tab of the Properties window. Set

Column Count: 2
Column Widths: 0

Thus the combo is bound to the autonumber field. It displays the
autonumber with width 0 (i.e., doesn't display it) and fills the rest of
the control with the second column, your text description. The
drop-down arrow of the combo will not display in the report -- it'll
look just like a textbox. Make sure the combo box is wide enough to
display all the text you'd like to appear on the report.

HTH,

Kevin
 
Kevin,

Your fantastic! This worked like a charm. Thank you so much. This is such
a helpful forum, I hope Microsoft continues providing it. Thanks once again
for your expertise.
 
Back
Top