RE: [MS_AccessPros] Need help on opening FORM

 

Kambiz

It's best to start a new thread when you have another question unless it is directkly related to the original thread.

In answer to your question about opening another form...

Private Sub Form_Close()

    DoCmd.OpenForm "YourFormName"

    Forms!YourFormName.Controls("YourControlName").SetFocus

    

End Sub

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Many thanks works great. Would you please help me with VBA procedure? I need a code for OnClose event of form "A", open form "B" and set focus on CERTAIN field in form "B"
Kambiz

 
Kambiz

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___