Move record of another form (1 Viewer)

munhun

New member
Local time
Today, 15:27
Joined
Nov 23, 2018
Messages
8
There are two different forms.
One form is a pop-up form. .... A form
Another form has subforms. .... B form ( sub form is C )

When I click the button in the popup form, I need to move the record of the subform of another form to the next record.

I tried like this:

1. In the subform ... ( C form )

Public Sub next_record()
DoCmd.GoToRecord , , acNext
End Sub

2. In the A form (pop up) ...

Forms!A!C.form!id.SetFocus ( or DoCmd.GoToControl "id" )
Forms!A!C.form.next_record

But it doesn't work.
Can someone please tell me how to fix it.

I can also get a response by email. ( jeongmunhun@gmail.com )
 

Attachments

  • img2.png
    img2.png
    14.3 KB · Views: 96

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:27
Joined
May 7, 2009
Messages
19,246
Use:

Forms!FormB!FormC.Form.Recordset.MoveNext

Last 2019, i also have my korean boss, Mr. Mun.
 

Users who are viewing this thread

Top Bottom