Access Problem

[Atomic]

I have a database at the moment with just the one table that records various car details and charges.

However, there are two field in the table/form in which I have a minor problem:-

'Make'
'Model'

The make is the make of car and obviously the model is the model. Instead of the user typing in the car names I want them to be able to do it from a drop down list. However, I also want them to be able to select for example Ford brand of car in the 'Make' field on the form and then in the 'Model' part of the form for the user to only see the Ford car models.

Can this be done, and if so how?

Also is there any site out there that has a massive list of car makes and models? Just thinking it may save time typing them all out

Thanks for any assistance.

 

[MarcLister]

Combo boxes? http://www.thescripts.com/forum/thread515605.html

Or SQL. Some statement like "SHOW * FROM MODEL WHERE MAKE = FORD" (pseudo code btw )

http://office.microsoft.com/en-gb/access/HA101130521033.aspx?pid=CH100645661033
http://www.techonthenet.com/access/comboboxes/linked_combos.php
http://msdn2.microsoft.com/en-gb/library/bb404901.aspx

etc.

Any help to you?

 

[suarve]

I have a database at the moment with just the one table that records various car details and charges.

However, there are two field in the table/form in which I have a minor problem:-

'Make'
'Model'

The make is the make of car and obviously the model is the model. Instead of the user typing in the car names I want them to be able to do it from a drop down list. However, I also want them to be able to select for example Ford brand of car in the 'Make' field on the form and then in the 'Model' part of the form for the user to only see the Ford car models.

Can this be done, and if so how?

Also is there any site out there that has a massive list of car makes and models? Just thinking it may save time typing them all out

Thanks for any assistance.

Read up on dependent combo boxes. Quite a decent tutorial here