Advertisement

04.09.2005 at 01:49PM PDT, ID: 21382867
[x]
Attachment Details

How can I close the form by Event?!!

Asked by yzn in Databases Miscellaneous

Tags: close, form, access

hi.

I am using Access VBA through Access 2002

1. I read a value through form XX by Text Box.
2. then (through Lost focus Event) I compared the value by using a condition which has writen by access vba code.
3. at right condition I called the close command DoCmd.Close acForm, "XX"  to close the form.
4. But Error message was occured tell me that this command will not be executed through an Event.

My Question is : Why?!! and what is the correct way to close the form through an Event and without a Close Boton.

thanks.Start Free Trial
[+][-]04.09.2005 at 05:34PM PDT, ID: 13745536

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: close, form, access
Sign Up Now!
Solution Provided By: stevbe
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32