Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jan 28 12:06:43 CST 2004
Dear List: I am getting the following error message on a bound form: Error 2468 - You can't carry out this action at the present time. This form has a sub form linked to the main form by the main form's primary key. (Main form is P.O. Header, subform is P.O. Detail). I get this error if I try to delete two records in a row. DoCmd.SetWarnings False DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 DoCmd.SetWarnings True I also get this error after I try to add a record. The problem started because I wanted to get the last PO in the file, add one to the PO number, and put the prefix and the new PO number ito the new record: DoCmd.GoToRecord , , acNewRec 'If rstPOHeader.RecordCount <> 0 Then ' rstPOHeader.MoveLast ' Me.fldPOPrefix = Nz(rstPOHeader!fldPOPrefix) ' If IsNumeric(rstPOHeader!fldPONumber) Then ' Me.fldPONumber = rstPOHeader!fldPONumber + 1 ' fldPOOrderDate.SetFocus ' Else ' Me.fldPONumber.SetFocus ' End If 'End If 'If Nz(Me.fldPOPrefix) = "" And Nz(rstPOHeader!fldPOPrefix) = "" Then _ Me.fldPOPrefix.SetFocus Right now the code is commented out. If I uncomment the two lines: ' rstPOHeader.MoveLast ' Me.fldPOPrefix = Nz(rstPOHeader!fldPOPrefix) I get the error when I try to save: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 I checked the web and there is nothing. Has anyone encountered this before? Thanks and regards, Rocky Smolin Beach Access Software