Basing on combo box on another in a SUBFORM !

[Céline Brien]

Hi everybody,
I followed Microsoft Office Online procedures to create a combox box based
on another.
In a form, it worked perfectly.
But in a SUBFORM, the second combo is only showing items related to the
items selected in the first combo.
The link here is the Microsoft Office database modified to show the problem.
http://cjoint.com/?lmqhAmF0uZ
Can anybody tell me how to show all the items in the second combo box ???
Many thanks,
Céline

 

[Douglas J. Steele]

I'm not sure that your problem is because it's a subform, or that your
subform uses a continuous form.

See whether the approach I describe in my February, 2006 "Access Answers"
column in Pinnacle Publication's "Smart Access" solves your problem.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Céline Brien]

Hi everybody,
Hi Steve,
Thank you so much for your answer.
I opened your database AA200602 and pressed the Working button. You seem to
have the answer there !
I printed your PDF document and will try to adapt your solution to my
database.
You've made my week ;-)
Thanks again,
Céline

 

[Van T. Dinh]

Mr Steele esq. is probably upset that you called him Steve ...

 

[Douglas J. Steele]

Nah, that doesn't particular bother me.

Now if she'd called me late for dinner (or, even more relevant, predinner
drinks...) <g>