Goto a new record in tabbed subform

[snoopy2003]

Hello,

I have a form (frmWorker) with tabbed subform within it (subfrmPayments)
(I created a tabbed form and added it as subform to a form).
Each tab is a continues form.


I wish each tab to display all the records and goto new record line.
In the On_Load event of the main form, I tried to focus on a field in the tabbed subform from the main form, but it didn't work.

If Forms!frmWoker!subfrmPayments!subfrmPayType1.Form. RecordsetClone.RecordCount > 0 Then
Forms!frmWoker!subfrmPayments!subfrmPayType1.SetFo cus
Forms!frmWoker!subfrmPayments!subfrmPayType1.Form! Amount.SetFocus
DoCmd.RunCommand acCmdRecordsGoToNew
End If

Can you help me ?

[djoosten]

Try moving your code to the On_Current event of the Main Form. I don't think it is able to synchronize the sub-form since the Main forms record has not been established. Just my quick thoughts.

[ajetrumpet]

Try moving your code to the On_Current event of the Main Form. I don't think it is able to synchronize the sub-form since the Main forms record has not been established. Just my quick thoughts.

that will not do it on it's own. this is, unfortunately too complex to figure out on your own if you're a newbie. snoopy, take a look at this: http://www.access-programmers.co.uk/...d.php?t=145533

In that thread, I cover most of what you're going to need. the syntax that's needed can also be found there. good luck, bud!

[snoopy2003]

Thank you for your help.
It is a helpful link with clear and excellent explanation.
I tried to figure how to write it correct for the whole night with no success.

Now, Its clear.


Thank you