Question on User Forms and Command Buttons

[TotallyConfused]

First time working on User Form. I have created a Main form and 3 additional
forms. I want to keep this as simple as possible. My main form consists of
3 command buttons enabling user to click and go to a specific form. I also
have an exit button. However, I want to give the user a chance to cancel
before exiting. How do I do this?

I also have another question once all the forms have been filled I woud like
the user to return to the main screen and submit and the form to be able to
add all the data to the db worksheet. Is this possible all at once or is it
better to go from each form and submit data from each single form?

Any help will be greatly appreciated. Thank you.

 

[carlo]

You mean, if the user presses the exit button, he should be asked if
he really wants to leave??

----------------------------------------
private sub MyExitButton_click()

if msgbox("do you want to go", VbOkCancel, "Leave??") = vbok then
'whatever you want to do
unload me 'closes the form
me.hide 'hides the form
activeworkbook.close 'closes the workbook
end if

end sub
----------------------------------------

If you hide the forms (see above) they are still accessible with
myform1.mytextfield.
If you unload them, the data in the fields is lost.

it should be possible, but I never did it. You could add a page
control on your main form, then you wouldn't need to have 3 different
forms!

hth

Carlo

 

[TotallyConfused]

Hi thank you for responding. What do you mean add a page control? I am
sorry but this is the first time working with User Forms. Reason for
creating 3 different forms, is for the form not to be too busy for the user.
Would I get the same effect with page control? Thank you.

 

[Bob Phillips]

He means the multipage control, the one in the toolbox that looks like a
tabbed image that you often see in dialogues.

The form would not be too busy, as the user would only see one page of the
multipgae at a time, although you would need to validate that they have
processed all pages.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[TotallyConfused]

Okay I get it. How would I validate on a multipage? Could I apply the same
validation having 3 forms? Thank you.

 

[Bob Phillips]

Yes, of course. You have two options, validate each page as you leave it, or
have an OK button and validate them all from there.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[TotallyConfused]

Thank you but how do I validate all pages on main screen? Could you provide
me a small sample? I imagine it would be with a "command button" named
"submit".

 

[Bob Phillips]

You can validate the textboxes etc just the same as if they were all on a
single form,you do not need to reference them through the multipage control.



--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)