OpenForm Macro in Form

  • Thread starter Thread starter LadyLazarus
  • Start date Start date
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?
 
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
 
Back
Top