S
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
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