card selection

[ErikVI]

hi,
I want to make a little db (see attachement) for cars.
i have tree tables for the moment:
brands (audi, bmw, ...)
types (325i, A1, A2, ...)
both tabels make a car (a brand and a type)
the tabls stock geves a overview of the stock.

now I want to make a form for the stock.
On the form I want to select a brand.
in function of that brand I want to see the correct types to selct
ex.
If I select Audi, I need to see te types A1, A2, A3, ...

can someone help me please?

thnx

 

[PHV]

Have a look here:
faq702-4289
faq702-4640

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya ErikVI . . .

I'm using 2003. Any chance you can convert to 2003 and provide another link?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[ErikVI]

hi,
I'm using access 2010.
how can I convert the db to 2003?
I clicked on Save As ... but the option 2003 isn't available

 

[TheAceMan1]

ErikVI . . .

Any prior version 2000, 2002 will do.

Have a look here Save .accdb as .mdb

[blue]Be sure to backup the file before converting![/blue]

[blue]Your Thoughts? . . .[/blue][blue]Your Thoughts? . . .[/blue]



See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]