Print Report Problem

[Bob]

I have a Form that has 12 Combo boxes on it that come from different
queries, Once I select my data into these 12 Combo Boxes , how can I arrange
for the report to print them.....................Thanks Bob







..........Jenny Vance

 

[John Vinson]

I have a Form that has 12 Combo boxes on it that come from different
queries, Once I select my data into these 12 Combo Boxes , how can I arrange
for the report to print them.....................Thanks Bob

You're not putting the data "into 12 combo boxes".

A Combo Box is a *tool* that gets data from one source (the combo's
row source) and puts it into another (its Control Source, usually a
field in the Table upon which the form containing the combo is based).

You would base your Report - not on the Form, not on the Combos - but
on a query based on the table.

Since you haven't chosen to post any description of your tables, how
they're related, or anything else about where your data resides,
there's no way for us to help you set up this query.

Stop, and step back. Build your Tables - first. They're the foundation
of your application. Be sure the tables are properly normalized.

Then design a Form (which will surely include combo boxes, and
probably other tools) to populate the table (or tables).

Create a Query joining your data table to the various lookup tables.

Finally create a Report based on that query.

For some resources see

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

John W. Vinson[MVP]

 

[Bob]

Thanks John, But the form is just for a printing source, Printing data on
all ready printed forms from another Site
I can added other data to the combo boxes even if there not in my query, and
I made text boxes on my report with Control source i.e.:
=Forms!frmHorseReg!Name And as long as I keep the form open i can print it,
Thanks Bob