i have multiple forms. i have two command button on frm1 and 1 in frm2. what i want to do is that based on which command button is pressed from frm1 frm2 will display another form. i don't really know where to start
i have multiple forms. i have two command button on frm1 and 1 in frm2. what i want to do is that based on which command button is pressed from frm1 frm2 will display another form. i don't really know where to start
Hello RonMexico,
Welcome to the Forum!
You can use the "Tag" property of a UserForm, which is a string, to hold the name of the button that pressed on that form.
Saving the Name of the Button on UserForm1
![]()
Please Login or Register to view this content.
Checking Which Button was Pressed On UserForm2
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Please don't quote whole posts unnecessarily.
It's often much easier to code using a MultPage control on one UserForm than using multiple userforms
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks