parameter query.. Urgent, pl help

[gdanalakshmi]

I have a parameter query that accepts 2 parameters. If one parameter is 2 , then I donot want to check for the second parameter valus.

Is there a way to do it ??

 

[Elana]

Use VBA code behind your form to perform this check, something like:


Select Case formfield1

Case 2
perform some action and don't look at the other field

Case Else
select case formfield2

case (whatever value you want to check for)
perform some action

case else
do something else
end select

End Select


HTH