Name Badge Print

[steve carp]

I have a database for hot air balloon flights where I am
trying to print a report of only one record based on the
user selecting from a combo box.

The "Passengers" table is related to a "flight" table,
which holds flight number, and a "pilot' table, which
holds the relationship between flights and pilots. I
want the user to be able to select a passenger from a
combo box, then print a report with all those fields
based on that passenger. For instance, if the user
selects John Doe, I want to print a report (actually a
name tag badge) with John's name, the flight number john
has a relationship with, and the pilot's name that has a
relationship with that flight. I ONLY want to print the
one recordset (as it is a name tag.)

How do I set up the form? I imagine I'd just place a
combo box on there that shows the passenger table? Then
a command button to do something? Thanks a lot for your
help, everyone.

Steve C

 

[Roger Carlson]

On my website (see sig below) are a couple of small sample databases which
might help: "PrintOneLabel.mdb" and "MultipleLabelsOffset.mdb". Each has an
explanation included.

 

[Guest]

Roger Carlson is the man.

-----Original Message-----
On my website (see sig below) are a couple of small sample databases which
might help: "PrintOneLabel.mdb"

and "MultipleLabelsOffset.mdb". Each has an