Refering to fields on a subform

[Shaun Allan]

I've got a music database with fields for Artist and
Title, amongst others. They appear on a subform
frmMusicDetails placed on the main form frmMusicRecords.
I've got the Artist, using DISTINCT, to only list each
artist once (for example Westlife have 3 entries). My
problem is getting the Title field, once an artist has
been selected, to only list the albums by that artist, and
not every album title I've got. I can do this on a single
main form, but when it's done on the subform, it doesn't
work.

 

[Wayne Morgan]

Do you have a unique ID field for each artist and is that field also part of
the recordset for the subform? If so, then use this field as the
Master/Child field links for the subform. With the main form open in design
mode and the subform NOT selected, right click the subform and choose
properties. You should see these two items on the Data tab.