Going to another form

[Greta]

Access 2002...
I want to go to a different form if "Failed" is entered
into a control. What's the best way? I'm trying to do an
If statement...but I think there's probably an easier
way...and suggestions?
Thanks,
Greta

 

[Fredg]

Greta,
One way is to code the Control's AfterUpdate event:
If Me![ControlName] = "Failed" then
DoCmd.Openform "FormName"
End If

That will open the form, however I don't know what else to do with it, so it
that's all you want, great. If you also wish to stop any further processing
of the original form, you probably want to open the 2nd form as dialog:
DoCmd.OpenForm "FormName", , , , , acDialog
Processing on the first form will stop until you close the 2nd form.

 

[Greta]

Now it's telling me that the form I want it to open is
spelled wrong or doesn't exist...but it's spelled right
and does exist. Any ideas?
Thanks,
Greta

-----Original Message-----
Greta,
One way is to code the Control's AfterUpdate event:
If Me![ControlName] = "Failed" then
DoCmd.Openform "FormName"
End If

That will open the form, however I don't know what else to do with it, so it
that's all you want, great. If you also wish to stop any further processing
of the original form, you probably want to open the 2nd form as dialog:
DoCmd.OpenForm "FormName", , , , , acDialog
Processing on the first form will stop until you close the 2nd form.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Access 2002...
I want to go to a different form if "Failed" is entered
into a control. What's the best way? I'm trying to do an
If statement...but I think there's probably an easier
way...and suggestions?
Thanks,
Greta

.