Another thing i'm stuck on

[Durks123]

Right, posted a week or so ago about designing a vehicles for sale database and havin combo boxes relate to vehicle make model. Now what i would like to do is have the year of the car reflect upon the make model that is selected. i.e. Iveco Supercargo was made from 1995 - 2000 for it to only display these years and if you select Daf LF which was made from 2000 to present for the years combo box to reflect this.

Can this be done and if so how would i go about it. Please be aware i am not an experienced access user in this respect.

[alansidman]

I believe that you will need to have cascading combo boxes to achieve what you are looking for. Look at this link on cascading combo boxes.

http://www.fontstuff.com/access/acctut10.htm