Set Focus on Sub Form and go to Control

[Dave Elliott]

Main form is named Add Products and Sub-Form is named Add Products
SubForm
On Open I want the focus to go to the sub-form and then go to control
Product Name
on the sub-form.
How Can I Do This ?

Thanks in Advance...
--
---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://ma*****************@sbcglobal.net

[Allen Browne]

Open will be too early. Try the Load event of the main form.
Set focus firstly to the subform control, and then to the control in the
subform.

Private Sub Form_Load()
With Me.[Add Products Subform]
.SetFocus
.Form![Product Name].SetFocus
End With
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave Elliott" <do************@sbcglobal.net> wrote in message
news:VX********************@newssvr11.news.prodigy .com...

Main form is named Add Products and Sub-Form is named Add Products
SubForm
On Open I want the focus to go to the sub-form and then go to control
Product Name
on the sub-form.
How Can I Do This ?