Macro Help

[KEKeogh]

I am trying to do a macro to do the following steps.

1. Open "OpenClaims" Form
2. RunMenuCommand "Find"
3. If no search item found then Close "OpenClaims" form
4. Open "MRIClaims" Form
5. RunMenuCommand "Find"


In layman's terms I want a macro to open the 1st form let me search there and if the search criteria is not met then close and open the other form to search there instead.

I keep getting stuck how to word the if statement in step #3. I can get all the other pieces to work but not that one.

Thanks in advance
Kathie

 

[KEKeogh]

Oh! And I'm using Access 2013.

Sorry!