Move to next record

W

Wavequation

I have two forms open. One is a main form (FrmProjectInfo) with a subform
(Child98), and the other is a pop up. The pop up form has data I want to put
into the subform. The following code, run from the pop up, does this:

Forms![FrmProjectInfo]![Child98].Form![Description] = Me.List13
DoCmd.RunCommand acCmdSaveRecord

I would like to move immediately move to the next record of the subform,
which is configured as a continuous form. The following code does not work:

DoCmd.GoToRecord acDataForm, "Forms![FrmProjectInfo]![Child98]", acNext

Access tells me that the form is not open. I tried this iteration of the
code:

DoCmd.GoToRecord acDataForm, "Forms![FrmProjectInfo]![Child98].form", acNext

this doesn't work either...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write Conflict Dialog Box 0
Populate main form from subform record 0
VBA for Next Record with and without Filtering 2
You can't go to the specified record error 1
Subform Navigation 4
Move to next record on subform 2
continuous form next record 5
GoToRecord for a subform 4

Top