how do you close a form from a cancel button?

[christheprogrammer]

I have tried 'Unload Me' but I get an 'ActiveX could't create object' error (number 429).&nbsp;&nbsp;My cancel button will not work arrrrggg!!&nbsp;&nbsp;I also tried using End but to no avail.&nbsp;&nbsp;Help please if you know!!<br>Thanks a bunch<br><br>Chris

 

[rhicks]

Use this line of code:<br><br>DoCmd.Close acForm, Me.Name<br><br>Note that this not cancel any entry, it only closes the currently active form.<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[Oxycutor]

I always use this for my cancel buttons.<br><br>Me.Undo<br>DoCmd.Close<br><br>Oxycutor