want to show form dynamically

[sv_bhaskar]

Hi

I am saving form names in database.
I like to show the form dynamically by picking up the values from the db.

for ex:

"form1" is retrieved from db.Now i like to run the form form1.

How can I show?


Thanks
Vijay

[abhid]

use forms collection
like
dim f as form
for each f in forms
' add f.name
next
but it gives loaded forms only

[honeybee]

I don't think it's possible directly.

You can use a conditional construct to check the value picked up from the database and then show the relevant form, for e.g.

If FormName = "Form1" Then
   Form1.Show
ElseIf FormName = "frmMain" Then
   frmMain.Show
End If

.