is there any way around this?

[eclecticbmxer]

Hi, I'd like to start by thanking you for reading this post. Ok, now for the question:
I created a query-based combo box that would be populated with a customized list, based on a value in another combo box which is in the same form. When I try to access the drop-down menu for the query-based combo box, it prompts me for the value which should be derived from the other combo box.
It seems as if Access has a problem with using values from the same form. Is this so? If not, what should I do to correct this problem? And if it is, is there any way around it?
Thanks again.

 

[Rich]

There have been numerous posts here regarding cascading combo boxes which you can search for help on, or download an example from Candace Tripps site

 

[eclecticbmxer]

Thanks Rich, that is much appreciated