Set focus to a Control on a subform

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
data from one form to another. 2
Speed Issue on Server 4
form referencing 1
Activate cmdBotton on another Form 2
Using OnClick of a label to set focus to a control 9
open form to specific record number 5

Back
Top