469,926 Members | 1,715 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

vba to activate a command button in a different though open form

my primary form, formlauncher goes visible=false when i click any of 6
buttons on it that open other forms. one of those forms (only one) has docmd.
maximize in it's open event. when any of these forms close, they all set
formlauncher visible=true. so here's my dilemma:

when this one maximized form is closed, formlauncher is maximized, which i do
not want. i can't get it to movesize on any event procedure for when it is
visible=true because the code for that is in the closing event of each of the
6 forms. i put a command button on this form with docmd.restore as it's
click event. so how do i activate this button (cmdrestore) on formlauncher
when formproductlist closes? thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1
Dec 14 '05 #1
2 2928
In the maximised form's close event put Docmd.restore

Dec 15 '05 #2
no, no... that's far too simple and effective. i need a different way to do
it that is far more complicated that make's the time i've spent trying to
figure it out not seem like such a waste of time. your method works, sure,
but what about asthetics? where's the hours of grueling work and pages of
code that i was asking for? i mean, i guess it's ok if you want results.

sigh.. i'm such a bonehead. thanks. 8)

Macca wrote:
In the maximised form's close event put Docmd.restore


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200512/1
Dec 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Samantha Smit | last post: by
3 posts views Thread by Salad | last post: by
5 posts views Thread by juststarter | last post: by
2 posts views Thread by Kishan Hathiwala | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.