The Else statement worked.  I had tried that but put the OpenForm in the wrong place.  Thanks so much for your help! 1 more question.  which takes priority, the build event or the VB code? When I change orer in Build event then "View Code". It doesn't seem to match.Thanks again!

---

Reply from Alex Hedley:

You can only pick from 1 of the 3 options for an event.
So there's Expression Builder, Macro Builder and Code Builder.
If you choose Macro Builder you can then convert it to VBA.
When it's VBA you should get the [Event Procedure] next to the Event in the Property Sheet.
If you click the "..." It will open it back up in the VBA editor where you can make amendments to your code.
Make sure to save this, save and close the Form then reopen it for it to take effect.