On Form Close Code. - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

On Form Close Code.

Werner Mildt

3 months ago

I am trying to click a button to a previous form
on close at the current form.
Code:
Forms!RecurringF2!AllBtn.SetFocus
Forms.RecurringF2.AllBtn_Click
Error: See picture.
Is there a way get it working?
Werner

	Werner Mildt OP @Reply 3 months ago

	Kevin Robertson @Reply 3 months ago
Make your own Sub Routine and call it from both places.

	Sandra Truax @Reply 3 months ago
One thing, the correct format I believe is: Forms!RecurringF2!AllBtn_Click I pretty sure it still won't work because AllBtn_Click is a private event procedure on another form. Access won't reliably let you call it from outside that form. I'm with Kevin, move the code from the AllBtn_Click to a Public Sub, and then you should be able to call it from both places.

	Werner Mildt OP @Reply 3 months ago
Hi Sandra, Forms!RecurringF2!AllBtn_Click gives the same error message. I have tried that already. Maybe I could get some help with Sub Routine. Like how and where to put it. I don't have much experience with it? Thanks, Kavin and Sandra

	Sandra Truax @Reply 3 months ago
What is the code in the AllBtn_Click event?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen