View Single Post
  #1  
Old May 25th, 2010, 03:41 PM posted to microsoft.public.access.tablesdbdesign
K[_4_]
external usenet poster
 
Posts: 25
Default How to add record in Subform which is in another Subform

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