I would like to be able to have a form return a value to another form, in much the same way that msgbox() and inputbox() do. Is there any way to do this?
Some more specifics:
I don't want to use msgbox() or inputbox() because of the type of data I'm trying to collect. The return value will be fairly simple (initially, it would just be true or false), but will have different results in the calling forms.
Suppose there's some forms, Form1, Form2, Form3,... I want to call Form2 from other forms to validate some data entry. For instance, Form2 might ask the user for a password. If the user enters the right password, then the calling form (Form1) stores some data; if the password is wrong, Form1 rejects the data. If the calling form is Form3, then a correct password would result in the opening of Form4.
Thanks!
Some more specifics:
I don't want to use msgbox() or inputbox() because of the type of data I'm trying to collect. The return value will be fairly simple (initially, it would just be true or false), but will have different results in the calling forms.
Suppose there's some forms, Form1, Form2, Form3,... I want to call Form2 from other forms to validate some data entry. For instance, Form2 might ask the user for a password. If the user enters the right password, then the calling form (Form1) stores some data; if the password is wrong, Form1 rejects the data. If the calling form is Form3, then a correct password would result in the opening of Form4.
Thanks!