Linking Combo Boxes

[Whitestar]

I'm doing a project where people are going to be selecting artists and tracks from combo boxes to go on a list.

I was wondering if it is possible to connect the Artist combo to the track combo so that the tracks that appear in the track combo are the tracks by the artist that is selected in the artist Combo.

 

[gator]

Sounds like the easiest way to do this might be to create a form with a combo box on it for artist and then create a subform with tracks, then link them on the artist name or id.

-gator

 

[jmcchristian]

Here is an article that I believe will help you.

Microsoft Knowledge Base Article - 209595

http://support.microsoft.com/default.aspx?scid=kb;en-us;209595

 

[Whitestar]

thanx jmcchristian that helped loads