Hello Experts!
I am using Access 2002 to develop a small catering database and am having a problem setting the focus to a control on a subform. I have a main form (frmMain) and 2 subforms (s1frmCustomers, frmCustomer) one of which (frmCustomer) is contained in the first subform. It looks like this:
1. frmMain
a. s1frmCustomers
i. frmCustomer
frmCustomer displays the customer name and address information and does not allow edits. However, if a new customer needs to be input, this is where I want the user to enter it. On s1frmCustomers I have a button (cmdAddCustomer) that when clicked sets the DataEntry property of frmCustomer to TRUE and then needs to set the focus to the first field (LastName).
Here is the code for the OnClick event of cmdAddCustomer:
Private Sub cmdAddCustomer_Click()
Dim f1 As Form
Set f1 = Forms!frmMain!s1frmCustome
f1.DataEntry = True
f1!LastName.SetFocus
End Sub
I do not get any errors and it works just like I want it to, except the focus is not shifted to the LastName field. I know all the user has to do is click into the field and start typing, but I want to avoid the extra step.
Thanks in advance for your help!
Dave Savittiere
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Try adding:
f1.AllowEdits = True
OR
Set the tab order of the form to make LastName the first tab stop and then just set focus to the subform.
me.s1frmCustomers!frmCusto
PS: I agree with 1W about the variable usage. Unless you are doing more than this with the var, there is no gain, and you just have to destroy it one nanosecond after you instantiate it.
PSS: Try using the "Me" object to reduce coding keystrokes
regards
Jack
This is what worked for me. I put together a sample db like you have.
I found out that I needed to set focus to the 3rd form first, then set focus to the field on the 3rd form.
This did the trick. Otherwise, my statement like yours did nothing.
Forms!form1!form2!Form3.Se
Forms!form1!form2!Form3!tx
Robert
Thank you all for your prompt and helpful replies. I tried everything everyone suggested and stopped the variable usage for such a short code. But, it seems that no matter how you code it, you do have to set the focus to the subform first and then set the focus to the control with another line of code.
Thanks again for your help. EE once again proves to be THE place to go when I am stuck and need the help of truly kind people!
Dave Savittiere
Business Accounts
Answer for Membership
by: 1WilliamPosted on 2003-08-12 at 09:11:35ID: 9131286
since you are only using the form reference twice, no point in wasting the resources for a variablePrivate Sub cmdAddCustomer_Click()
Forms!frmMain!s1frmCustome
Forms!frmMain!s1frmCustome
End Sub