Name Badge Question

[steve c matco]

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

 

[AlCamp]

Steve,
You'll need to place a combo box on your form that displays Passengers.
Say it's [frmYourForm] and it's [cboPassenger].
In the query behind your report put the following criteria in the
Passenger field...
=Forms!frmYourForm!cboPassenger
(I take it there is only one record (flight) for your John Doe)
To speed things up, you could use the AfterUpdate event of cboPassenger
to open the report and print the tag... rather than an seperate button.

hth
Al Camp