S
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 combo box, using DISTINCT, to only
list each artist once (for example Westlife have 3 entries
on the database). My problem is getting the Title field
combo, 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 with the Row
Source set to "Select tblMusic.Title where
tblMusic.Artist=forms!frmMusicDetails.Artist" (or
something like that), but when it's done on the subform,
it doesn't work.
Title, amongst others. They appear on a subform
frmMusicDetails placed on the main form frmMusicRecords.
I've got the Artist combo box, using DISTINCT, to only
list each artist once (for example Westlife have 3 entries
on the database). My problem is getting the Title field
combo, 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 with the Row
Source set to "Select tblMusic.Title where
tblMusic.Artist=forms!frmMusicDetails.Artist" (or
something like that), but when it's done on the subform,
it doesn't work.