using Iif on a form, having an issue?

[Darla]

Hi everyone! I have a form that currently has a button, where if you click it, it will open "Form 1", no problem. But I want to add a little bit to it. I have another field in the form, where if the value is "77", then I need the click to open "Form 2", but otherwise if it's anything else, "Form 1" like usual. I've been struggling with this and can't seem to figure out how to do it, could someone point me in the right direction please?

[RuralGuy]

Show us what you have for the button that works.

[ranman256]

Sub btn_click()
  If me.field = "77"  then
      Docmd.openform "form2"
  Else
     Docmd.openform "form1"
  end if
end sub

[Darla]

Thank you!

[RuralGuy]

I marked this thread as *Solved* for you using the *Thread Tools* at the top of the thread.
https://www.accessforums.net/showthread.php?t=1828