Going to another form

  • Thread starter Thread starter Greta
  • Start date Start date
G

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
 
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.
 
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.


Greta said:
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
Click to expand...




.
Click to expand...
 
Back
Top