Prev: Combo Box Auto expand List Width
Next: Adding data in a continuous form
From: K on 25 May 2010 07:50
Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB"
is on Form called "Main". On "SubB" I have button called "Add New
Record" and I got macro (see below) on this button's click event.

Private Sub Command1_Click()
Me.SubA.SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

When I open Form "SubB" and click button, macro works but when I open
Form "Main" and click button which is showing in "SubB" subform, macro
don’t work. I tried below macro but I don’t work

Private Sub Command1_Click()
Forms![Main]![SubA]![SubB].SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

Please can any friend help
 | 
Pages: 1
Prev: Combo Box Auto expand List Width
Next: Adding data in a continuous form