Hello , I have three forms , based in the same table , in order to show the first , second and third records.
The following code in each form works properly:
Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "Form 1", acNormal
DoCmd.GoToRecord acDataForm, "Form 1", acGoTo, 1
End Sub
Each one is going to record 1 , 2 and 3 , this numbers given by an autonumeric field.
Now I want to see them as subforms in a report , but it fails and only the first record is showed in all the subforms.
I tried with subreports in a report , but doesn´t work .
As reports with this code retrieve the records I want , but no as subreports.
Can you give some idea about this?
Thanks in advance.
The following code in each form works properly:
Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "Form 1", acNormal
DoCmd.GoToRecord acDataForm, "Form 1", acGoTo, 1
End Sub
Each one is going to record 1 , 2 and 3 , this numbers given by an autonumeric field.
Now I want to see them as subforms in a report , but it fails and only the first record is showed in all the subforms.
I tried with subreports in a report , but doesn´t work .
As reports with this code retrieve the records I want , but no as subreports.
Can you give some idea about this?
Thanks in advance.