dependent combo boxes, behavior when choosing blank space

[crazygloo]

Hi,

I have a search form and 2 important comboboxes(CB)in it, where by selecting option1 or option2 in CB1, i get offered different data in CB2.

here's what i have:
In CB2 i added criteria:

[Forms]![myformname]![CB1name]

and in AfterUpdate of CB1 I made a Macro "Requery" with Control name: CB2name

And it works fine.

but the problem is, when i dont select anything in CB1, i dont have any data in CB2. So, instead of empty CB2, i would like to have both(all) data in it.

any idea how can i do that? What code to include?

Thank you so much

[jforbes]

Replacing:

[Forms]![myformname]![CB1name]

with:

[Forms]![myformname]![CB1name] OR NZ([Forms]![myformname]![CB1name], '')=''

will probably work. Query criteria gets evaluated to down to a Boolean of True or False, so just include a value that forces the Criteria to evaluate to True when there isn't a value supplied for your ComboBox. There is a lot of flexibility when going about this and the above is just one of the ways to do this type of thing. If you are still stuck after attempting this, post the entire RowSource for the ComboBox and we can get you sorted out.

[mbizup]

Another option is to use LIKE in the criteria:

LIKE  NZ([Forms]![myformname]![CB1name], '*')

The wildcard (*) will return everything if CB1name is blank/null.

[crazygloo]

Thanks, both of codes works so far.

I was planning to make that form as subform in tabbed navigation form. When selecting those two combo boxes in navigation form I get Enter parameter value warning: "Forms!myformname!CB1name".
Other combo boxes (not dependent) work fine.

[jforbes]

I don't have any experience with the Navigation Form, but a few other Experts on this site do.

I remember seeing this post, maybe it will help you: https://bytes.com/topic/access/answe...ntrol-subforms

[crazygloo]

Okay, thanks for help.