Basing on combo box on another in a SUBFORM !

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Céline Brien" wrote in message
...
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

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

"Douglas J. Steele" a écrit dans le
message de news: ...
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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Céline Brien" wrote in message
...
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

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

--
Van T. Dinh



"Céline Brien" wrote in message
...
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

Nah, that doesn't particular bother me.

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Van T. Dinh" wrote in message
...
Mr Steele esq. is probably upset that you called him Steve ...

--
Van T. Dinh



"Céline Brien" wrote in message
...
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