ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move to next record (https://www.excelbanter.com/excel-discussion-misc-queries/245504-move-next-record.html)

Wavequation

Move to next record
 
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...




All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com