combo box help

[micky5009]

Hello,

i have placed a combo box on my form and populated it with names fro
my table. I have then created a query that will give me all names an
record titles.

When I choose a name from the combo box I want a report of the title
that person has sung. I would like to put the titles in a list box an
print to a report.

any help would be much appreciated.

Thanks

mick

 

[Jeff Boyce]

Micky

You've described "how" -- let me try my hand at inferring the "what" you are
trying to accomplish...

You have a table with an "artist".

You have another table with record titles.

You have a third table to resolve the "many-to-many" relationship between
artist and record title (actually, you might need a record
title-to-song/track relationship before connecting an artist).

You want to be able to select an artist and get a report listing all record
titles (?and songs).

One approach would be to create a parameter query that selects record titles
for a given artist. Create a form on which you can select an artist (via a
combobox, with a row source from the "artist" table). Make the parameter of
the query point to the combobox on the form.

Create a report, based on the parameterized query. In the detail section,
use one field for the record title.

Add a command button to the form on which you pick the artist. Behind the
OnClick event for that button, open the report.

Since the report is based on the query, which is based on the artist in the
form's combobox, the report should list all titles for the selected artist.

Or have I completely misunderstood...?