setting focus to 3rd subform

[sipiaolin]

Now I am back to the original error: 2455 'You entered an expression that

has an invalid reference to the property form/report.'

Did I do the code right? Given your bang tip, this looks correct.

Me.Reservationfrm.Form.Jobfrm.Form.Invoicefrm.Form.AllowEdits = True
Me.Reservationfrm.Form.Jobfrm.Form.Invoicefrm.Form.AllowAdditions = True
Me.Reservationfrm.SetFocus
Me.Reservationfrm.Form.Jobfrm.SetFocus
Me.Reservationfrm.Form.Jobfrm.Form.Invoicefrm.SetFocus

Thanks again for helping me.

if you fire the sql the allowadditions will get bypassed
but you can also set
Me.Reservationfrm.Form.Jobfrm.Form.Invoicefrm.Form.AllowEdits = True
and
Me!Reservationfrm.Form.Jobfrm.Form.Invoicefrm.Form.AllowAdditions = True

HTH Pieter

Note: it is reccommended to use the . (dot) notation instead of ! (bang)
in
code, as it will at least throw an error at runtime.

Very good! But, I don't know how to ensure that I code properly to
ensure
the new record is allowed. Help?

:

think we solved it there

Pieter

Hmmmm....maybe you gave me a hint.

Jobfrm and its subform Invoicefrm are enabled and unlocked.
However --
maybe this? -- data entry is NO for Jobfrm and Invoicefrm.

This fails with 2105 "You can't go to specified record."
Me![Reservationfrm].SetFocus
Me![Reservationfrm].Form.Jobfrm.SetFocus
Me![Reservationfrm].Form.Jobfrm.Form.Invoicefrm.SetFocus

Hoping this sheds light, while I thank you for the help.