OpenForm Macro in Form

L

LadyLazarus

I have a criteria form with 2 dropdowns that filters a second form. I have
successfully added an "all" selection to each dropdown but I don't know how
to open the correct form when the user selects the "all" option from either
or both dropdowns. The setup is working fine when you choose something other
than the "all" option. Currently when you select the 'all' option a blank
form loads.

How do I do this?
 
C

Clif McIrvin

LadyLazarus said:
I have a criteria form with 2 dropdowns that filters a second form. I
have
successfully added an "all" selection to each dropdown but I don't
know how
to open the correct form when the user selects the "all" option from
either
or both dropdowns. The setup is working fine when you choose
something other
than the "all" option. Currently when you select the 'all' option a
blank
form loads.

How do I do this?
Click to expand...


You didn't give us much information to work with here....

Presumably your criteria is something along the lines of "Like
[dropdown].value".

Try something like:

If [dropdown].value = "all" then
[criteria] = Null
else
[your current code here]
endif
 
Top