Set focus to a Control on a subform

G

Guest

This is my problem. I have a form1 which has a subform1. On form1 I have a
button which opens form2. Once form2 is closed I want the focus to go to a
specific control (ctrl1) on subform1 in form1.

How can I do this programmatically on the OnClose in form2?

Thanks for any help!!!!!

Sarah
 
G

Guest

What you need to do is go into Visual Basic as you said on the OnClose event
and then add this code:

Forms![form1]![subform1]![ctrl1].SetFocus

Hope this helps
 
G

Guest

Thank you! That did the trick.

Have a Happy St. Patrick's Day!

Sarah

Chris said:
What you need to do is go into Visual Basic as you said on the OnClose event
and then add this code:

Forms![form1]![subform1]![ctrl1].SetFocus

Hope this helps

Sarah said:
This is my problem. I have a form1 which has a subform1. On form1 I have a
button which opens form2. Once form2 is closed I want the focus to go to a
specific control (ctrl1) on subform1 in form1.

How can I do this programmatically on the OnClose in form2?

Thanks for any help!!!!!

Sarah
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refer a control form a sub form 6
Update data in a form based on record selection in another subform 1
Speed Issue on Server 4
data from one form to another. 2
form referencing 1
open form to specific record number 5
Bookmarking a record in a subform. 4
Using OnClick of a label to set focus to a control 9

Top