how to open a form based on the text value in access 2003

R

rajeev

i have some forms. in one form i have only one textbox and one commad button.
if i enter one form name and click the button i need to open that fom.
example.
my form names are "account", "invoice", "report" and one mainform
i main form i have one textbox
if i enter a form name in textbox and click the command button. i need to
open that form.if i enter another form name and click the same button i need
to open the another form. how can i create this one. please give the code and
sample for above question.
thanking you
rajeev
 
R

Rick Brandt

rajeev said:
i have some forms. in one form i have only one textbox and one commad
button. if i enter one form name and click the button i need to open
that fom. example.
my form names are "account", "invoice", "report" and one mainform
i main form i have one textbox
if i enter a form name in textbox and click the command button. i
need to open that form.if i enter another form name and click the
same button i need to open the another form. how can i create this
one. please give the code and sample for above question.
thanking you
rajeev

DoCmd.OpenForm Me!TextBoxName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top