Microsoft Access Help Needed

[corsa_mark]

Basically I'm making a database in MS Access with drop down lists but I need to know how to "link" the drop down lists, eg if i click "Vauxhall" in the first one, the next one will automatically have vauxhall makes of cars in it. hope that makes sense, making the lists is no prob but i can't work out how to link them. i'm no good with the "visual basic" editor or what ever it is called, so i'm going to need some "dumbed down" instructions.

cheers

[corsa_mark]

bump

[DAIRX-8]

You mean

VX > Model > Spec

???

[gonkowonko]

dead simple :)

create 2 tables

1st create 2 fields an autonumber and a text field
call it manafacturer

2nd create 3 fields, autonumber, number(autonumber link from first table) and text
call it models

Write fill in ur manacfacurers then fill in the models table making sure u put a link id for the manafacturer

YOur first drop down list will contain a query with 2 columns the 1st being the ID and being hidden and the second the text

the second combo will be another query bascially showing the models where the link id = the frst combo box

Then stick a routine on the change of the first box requery the second

If you cant do it i can send u a sample via email or add me to msn and ill help :)

[Keith Fusco]

^ That's correct. I was going to maybe mention primary key's, but the obove method's probably the most easiest/effective to use.

[corsa_mark]

dead simple :)

create 2 tables

1st create 2 fields an autonumber and a text field
call it manafacturer

2nd create 3 fields, autonumber, number(autonumber link from first table) and text
call it models

Write fill in ur manacfacurers then fill in the models table making sure u put a link id for the manafacturer

YOur first drop down list will contain a query with 2 columns the 1st being the ID and being hidden and the second the text

the second combo will be another query bascially showing the models where the link id = the frst combo box

Then stick a routine on the change of the first box requery the second

If you cant do it i can send u a sample via email or add me to msn and ill help :)

totally lost me with the bit in bold, would you mind sending me the sample one please to trucker28@btinternet.com cheers

[gonkowonko]

sending it now mate ;)

[ka$h]

dead simple :)

create 2 tables

1st create 2 fields an autonumber and a text field
call it manafacturer

2nd create 3 fields, autonumber, number(autonumber link from first table) and text
call it models

Write fill in ur manacfacurers then fill in the models table making sure u put a link id for the manafacturer

YOur first drop down list will contain a query with 2 columns the 1st being the ID and being hidden and the second the text

the second combo will be another query bascially showing the models where the link id = the frst combo box

Then stick a routine on the change of the first box requery the second

If you cant do it i can send u a sample via email or add me to msn and ill help :)

You're enjoying this aren't you :|

Go on, just write the bit of vb to do it, you know it's short and simple and the best way to do it ;)

[gonkowonko]

You're enjoying this aren't you :|

Go on, just write the bit of vb to do it, you know it's short and simple and the best way to do it ;)

Thats what ive done and emailed it to him :P

Gotta love vb

But ive kept it simple as he not to sure on vba

[ka$h]

Thats what ive done and emailed it to him :P

Gotta love vb

vb or evb???? Now now Gary, calm down :nono:

[gonkowonko]

vb or evb???? Now now Gary, calm down :nono:
:| meant to say gotta love k :love:

[corsa_mark]

still need help on this, just can't get the tables to link together

[corsa_mark]

bump............don't even mind sending the database to someone to do for me, just that i'd love to find out how its done