manners
10-16-2001, 05:07 AM
I'm want to be able to attach code to a button so that when the button is clicked, the new form opens and the old form (with the button on)closes.
Can anyone give me any help please?
Can anyone give me any help please?
|
View Full Version : One form opens another one closes manners 10-16-2001, 05:07 AM I'm want to be able to attach code to a button so that when the button is clicked, the new form opens and the old form (with the button on)closes. Can anyone give me any help please? Randomblink 10-16-2001, 05:12 AM Here you go... http://pub95.ezboard.com/fcodesmithguildfrm20.showMessage?topicID=4.topic This has it laid out... Enjoy... rschultz 10-16-2001, 06:12 AM The following code Opens the Fiscal Search Menu form and closes the Main Menu form. Put it on the OnClick event of a button. DoCmd.OpenForm "Fiscal Search Menu" DoCmd.Close acForm, "Main Menu" Good Luck manners 10-16-2001, 06:15 AM Thanks a lot pal, much more professional! Randomblink 10-16-2001, 10:32 AM Shorter...? Yes... More Professional...? What the heck does that mean...? You have no error handling on the shorter version...And you are limited to a set form that you are opening... Not sure why you would be semi-insulting to a reply that didn't fit your requirements...especially when you never said you needed something short and sweet...Kinda rude... Well, your welcome anyway... Don't expect me to throw an answer at you in the future... manners 10-17-2001, 02:25 AM I think you took my message the wrong way as I was actually being sincere. I didn't refresh the screen, thus didn't see his reply when I sent the thank you message. I wasn't referring to rshultzs reply being more professional as I didn't try it that way as you replied first! I Randomblink 10-17-2001, 05:06 AM Mis-understandings...ahhhh... Gotta love em... Sorry man, I was having a horrible day when I saw that little number...and when I responded... I apologize...thanks for clearing that up... (meek look) Forgive me...sheesh! (Im an eeediot!) (glad I could help?) ian_ok 10-17-2001, 05:34 AM Glad to see you sorted your differences out......I now have a question. What is the difference between the two codes, apart from one being longer - wouldn't you have to enter the name of the form into each code? Ian Randomblink 10-17-2001, 06:23 AM No, you could actually enter a variable and create a text field/combo-box to select the form you wanted to open from there... (altho, in retrospect, you could do the same in the other...the quotes threw me off...) |