Finding a Record

[Crispy]

I have set up a music database with just over 1200 albums.

I have a combo box that is on a main viewing form which is itended as a
search tool for specific albums...because there are so many

Problem is that if I click on a specific artist and album in the combo box,
the form then displays the record that is the FIRST one in that list for the
artist...

(For exapmle - If I click on Neil Young Zuma (That is 2 fields - Artist and
Album Title) in the combo box, then the form displays the first album of
Neil Young ie - Neil Young After The Goldrush!)

Anyone have any idea how when I click on a specific Artist and Album in the
combo box, that the database will show me the correct album in the Form?

I hope I have explained that properly!

Thanks in advance

 

[Mike Painter]

I have set up a music database with just over 1200 albums.

I have a combo box that is on a main viewing form which is itended as a
search tool for specific albums...because there are so many

Problem is that if I click on a specific artist and album in the combo box,
the form then displays the record that is the FIRST one in that list for the
artist...

(For exapmle - If I click on Neil Young Zuma (That is 2 fields - Artist and
Album Title) in the combo box, then the form displays the first album of
Neil Young ie - Neil Young After The Goldrush!)

Anyone have any idea how when I click on a specific Artist and Album in the
combo box, that the database will show me the correct album in the Form?

You could use the artist and title as a key.
You could also use two boxes the first would contain artists and the second
would be the titles for that artist. That box would be used to pick the
album, which would contain the tracks.