Have to Click Save Close Twice - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Have to Click Save Close Twice

Mark Fannin

15 months ago

I have a form with a subform. When I clicked save and close it did just great - until I added a second subform. Now I have to click the 'save and close' button twice to close the form. Everything works fine for the form and both subforms, just have to click twice. The close command button VBA is: Docmd.runcommand acCmdSaveRecord then docmd.close acForm, me.name, acSaveYes. thanks in advance.

	Juan Rivera @Reply 15 months ago
you just might have to set the focus to the button... if the subforum has the focus then when you click the button the focus got moved to the button and then the second click fires off the action.

	Mark Fannin OP @Reply 15 months ago
That's it! You're a steely-eyed missile man Juan :) many many thanks

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

Next Unseen

New Feature: Comment Live View