But it will effect the current window.
I am first opening a window from another window:
Call DoCmd.OpenForm("search_customer", acNormal, , , , acWindowNormal)
if i do Me. ---- it will effect the current screen !
so a am looking for command maybe DoCmd or something that will cause effect on some other form/window
Hmm, in such a case I place the code in the form I open and pass the "action code" by using the OpenArgs of the OpenForm command. (Last parameter)
So on the "opening form code use::
Call DoCmd.OpenForm("search_customer", acNormal, , , , acWindowNormal,"Invisible")
And in the OnOpen event of the "search_customer" use:
If Me.OpenArgs = "Invisible" then
Me.visible = false
else
Me.Visible = True
endif
Getting the idea ?
Nic;o)