Solved SetValue in macro for continuous subform from the parent form

[saledo2000]

Hi Everybody,
I would like to setvalue of ID_No which is on the continuous subform from the parent form. I know how to setvalue of the ID_No on the parent form but would like to setvalue of the continuous subform from the main form when I open the next form using command button on the parent form. I have tried to do it and getting only the first record of the subform in my next form. I have noticed that value is passed for active record on the continuous subform. I am wondering how to move to the next record (little triangle on the record selector on the continuous subform). Is this possible to do it.
Thank you.

 

[June7]

Why do you even need SetValue for parent form? Isn't the key an autonumber field?

With a form/subform arrangement, all you should have to do is set subform container Master/Child Links properties. The primary key from main form will automatically populate to foreign key field of subform.

 

[arnelgp]

you need to SetFocus on the subform first before you can move to its record.
add a button that will move the record of your subform.
on it's click event:

Private Sub button_Click()
On Error Resume Next
Forms!mainFormNameHere!SubformNameHere.SetFocus
DoCmd.GotoRecord , , acNext
End Sub

 

[saledo2000]

you need to SetFocus on the subform first before you can move to its record.
add a button that will move the record of your subform.
on it's click event:

Private Sub button_Click()
On Error Resume Next
Forms!mainFormNameHere!SubformNameHere.SetFocus
DoCmd.GotoRecord , , acNext
End Sub

Thank you,
I thought the same. Thank you very much. Just wanted to be sure.
Cheers