Go To New Record on Subform

[Kirk P.]

I have a Form (frmCustomers) that contains a subform (sfrmRevenue). When
frmCustomers is opened, I want the curser to jump to a new record in
sfrmRevenue. I believe my code is correct, maybe I'm just not using the
correct event.

DoCmd.GoToRecord acForm, "sfrmRevenue", acNewRec

Help?

 

[T Best]

Hi Kirk, you need to setfocus to the subform first.

Me![sfrmRevenue].Setfocus
DoCmd.GoToRecord , , acNewRec

hope that helps
Ted

 

[Kirk P.]

Perfect. Thanks!

Hi Kirk, you need to setfocus to the subform first.

Me![sfrmRevenue].Setfocus
DoCmd.GoToRecord , , acNewRec

hope that helps
Ted

I have a Form (frmCustomers) that contains a subform (sfrmRevenue). When
frmCustomers is opened, I want the curser to jump to a new record in
sfrmRevenue. I believe my code is correct, maybe I'm just not using the
correct event.

DoCmd.GoToRecord acForm, "sfrmRevenue", acNewRec

Help?

 

[T Best]

Anytime...glad that helped

Perfect. Thanks!

Hi Kirk, you need to setfocus to the subform first.

Me![sfrmRevenue].Setfocus
DoCmd.GoToRecord , , acNewRec

hope that helps
Ted

I have a Form (frmCustomers) that contains a subform (sfrmRevenue). When
frmCustomers is opened, I want the curser to jump to a new record in
sfrmRevenue. I believe my code is correct, maybe I'm just not using the
correct event.

DoCmd.GoToRecord acForm, "sfrmRevenue", acNewRec

Help?