Problem with synchronization in form (1 Viewer)

M

miki033

New member

Local time

Yesterday, 18:34

Joined

Jun 11, 2013

Messages

7

• Jun 11, 2013

• #1

Hello!
I'm working in Access 2007 and I have a problem now. So, I created 3 tables:
a) cars
- ID_car
- ID_model of car
- ID_brand of car
b) models of cars
- ID_model of car
- ID_brand of car
c) brands of cars
- ID_brand of car

and I want to create form which will be able to synchronize brand and model of car. I mean, if I chose one brand of car (e.g. Renault), I can choose just the models belonging to this brand (e.g. Megane).

Is anybody who could help me in this case?

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 18:34

Joined

Aug 30, 2003

Messages

36,125

• Jun 11, 2013

• #2

Sounds like:

http://www.baldyweb.com/CascadingCombo.htm

 

M

miki033

New member

Local time

Yesterday, 18:34

Joined

Jun 11, 2013

Messages

7

• Jun 11, 2013

• #3

Thank you, but I don't quite understand this. I think my problem is more complicated and I am a beginner if it's about databases. Do you have any idea to solve my problem?

 

David R

I know a few things...

Local time

Yesterday, 20:34

Joined

Oct 23, 2001

Messages

2,633

• Jun 11, 2013

• #4

That's what pbaldy offered you./ If the first box is chosen, it limits the options in the second to those that are appropriate for the first selection.

 

M

miki033

New member

Local time

Yesterday, 18:34

Joined

Jun 11, 2013

Messages

7

• Jun 11, 2013

• #5

I don't really know how solve my problem. I would be glad if you could explain me what every word means in this sentence:

[Forms]![CascadingComboSample]![cboState1]

and tell me eventually what I should write in my case. It's really important project of database.

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 18:34

Joined

Aug 30, 2003

Messages

36,125

• Jun 11, 2013

• #6

[Forms] Leave as is
[CascadingComboSample] Name of your form
[cboState1] name of your first combo

 

M

miki033

New member

Local time

Yesterday, 18:34

Joined

Jun 11, 2013

Messages

7

• Jun 11, 2013

• #7

But in my case there are data form diffrent tables, I have a problem with this fact.

 

M

miki033

New member

Local time

Yesterday, 18:34

Joined

Jun 11, 2013

Messages

7

• Jun 12, 2013

• #8

It's working now. Thank you for your help!

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 18:34

Joined

Aug 30, 2003

Messages

36,125

• Jun 12, 2013

• #9

No problemo!