I have form names stored in database in Text type. I am unable to call to them in the program due to its string type.
if I give form = <formname in the database > it gives error type mismatch
Please help urgently

have you tried using the Forms collection to load the new form?

Dim frmNew As Form
Forms.Add "<<new form name>>"
Set frmNew = Forms.Item(Forms.Count - 1)
frmNew.Show ' or do whatever you like with it

hth
Phil

isn't that a little dangerous? what it someone modify the names in the VB project? (I saw this happens already...)
Anyhow, Phil suggestion is correct.
Marco

thx phil

Although I have tried your solution it gives error invalid property value at forms.add line
let me explain you my problem in detail I have many forms in my project depending on type of user I am to show a particular form. So
i have created a table in ACCESS and stored username and corresponding form name in the datafield as string for ex.

duser(text type) dfrmnm(text type in MSACCES)
A form1
B form2
C form3

Now at the time of excution I wish to show the form corressponding to User automatically.

I hope U have understand my problem

Waiting for your reply

Sorry phil I was doing mistake at forms.add = <name> although it should be forms.add name as told by you.
Now it is working. Thanks a lot again.