cascading combobox to limit choices

[megatronixs]

Hi all,

I found nice page to figure out the cascading combobox to limit the choces, but as hard as I try I can't implement it on my test database.
http://www.fmsinc.com/microsoftaccess/forms/combo-boxes/cascading.html

I guess there must be a simpler way to do this.
in the attached test database I have only the comboboxes connected to the correct tables.
Any idea how to get this solved would be really great.

greetings.

 

[bob fitz]

Like this?

 

[megatronixs]

Hi Bob Fitz,

Thanks a lot, very nice and easy
And I tried to solve it the hard way. Great solution I can use across different databases

Greetings.

 

[Synses]

HI,
Can you tell me how you did this (Cascading combo boxes) or point me to a way to learn?
I tried what you did for this person with my database - mimicking your record source info for the training topic - and failed.

I have a form with a field for "Client" (first) and a then field for "Facility" and I have got to learn to restrict the viewed choices on "Facilty" for only the facilities that are facilities of the chosen client.(and allow users to add - if needed - to both or either of them, and it automatically updates the tables with the add)

As reference, I have a table with one column of clients and one column of facilities that aligns all facilities with clients. Some clients have only one facility, some have many.

Searching for days and more confused now than when I started.

Any help appreciated!
Synthia

Like this?

 

[bob fitz]

See if the following link helps:
http://www.baldyweb.com/CascadingCombo.htm

If you still can't get it right, post a copy of your db