How to convert String to Form?

[gundie]

I have a table that contains a list of users and their access to certain forms.

[u]User[/u]       [u]Form[/u]
Tom        Form1
Jane       Form1
Jane       Form2
Peter      Form3

This table is read when the application first loads. How can I convert the form string (Form1, Form2, Form3...) to a form name where I can do something like:

Form1.show
Form2.show

Thanks a lot!

 

[Iamthestig]

You could use a Select Case on Form.

Dim objForm as New Form

Select Case Form
Case "Form1"
objForm = Form1
Case "Form2"
objForm = Form2
End Select

objForm.Show

 

[gundie]

Thanks for the reply! I should've mentioned that I wanted to make this as 'dynamic' as possible, meaning I don't want to use conditional statement if at all possible. I have over 70 forms in this project, and using conditional statement is hard to maintain.

 

[DaveInIowa]

Found this at

http://www.vbforums.com/showthread.php?s=&threadid=291544