If statement in macro (if certain form is open, then...) 1

[mark01]

Does anyone know how to put this in a macro...
IF form ABC is open (the current form being displayed on the screen), THEN open form XYZ.
I just don't know how to put it in the condition of the macro. Thanks.

 

[Joel27]

You really can't do anything that specific with a macro. Instead try using VBA to do what you want

 

[mark01]

OK, so how would I do that in Visual Basic then???

 

[Joel27]

I.e
This will give you some ideas

go to the ABC form goto properties> then go under Event> OnOpen


Private Sub Form_Open(Cancel As Integer)

docmd.openform "XYZ"

end sub

 

[mark01]

Well, I originally wanted to put in a macro that would be called autokeys, so I can use Ctrl-P to bring up my own print form, but I have 3 forms, and 3 different print menu's for each form. So I want to push Ctrl-P, and it will bring up the correct form for the current form that is open. So if I am in ABC form, I push Ctrl-P, and it will bring up ABC Print menu. Then if I was in XYZ form, I can push Ctrl-P, and it will bring up the XYZ print menu.(This is what I was hoping for)

 

[Lightning]

Try using the IsLoaded function.

This is not a built-in Access function, but it is in the Northwind sample database that is included with Access. Import the module from Northwind into your db and then use it as you would any other function.

Something like:

If IsLoaded(Form1) Then
    ......  'Do whatever
Else
    If Isloaded(Form2) Then
        ...  'Do Something else
    End If
end If

HTH

Lightning

 

[tlbroadbent]

HTH,

Thanks for the tip. That's a very useful function. Terry

http://members.home.net/tlbroadbent/index.htm

 

[jfhewitt]

If you want to open form B while form A is open, why not just put in a command button to open form B on click??