Cascading Combo Boxes - How to deal with one being empty?
On Tue, 27 Oct 2009 07:55:01 -0700, Marc T
wrote:
Hi again,
I have a set of three cascading combo boxes for the following;
Supplier Code, Doc Number, Revision
all is working great, but what I'd like to do is allow the Doc Number combo
to show data for all suppliers if the Supplier Code combo is left empty. At
the moment it shows as a blank if no supplier is selected.
Any help would be great!
Marc
Use a criterion
[Supplier Code] = Forms!yourform!comboboxname OR Forms!yourform!comboboxname
IS NULL
as a criterion in the doc number combo's row source.
If this isn't making sense please post how you're doing the cascade.
--
John W. Vinson [MVP]
|