[AccessD] Error 2468 - You can't carry out this action at the present time.

Right off the top of my head, it has to do with the movefirst, movelast.  I
ran into this when converting A97 to A2K.  Code worked in A97, not A2K and
M$ said this was designed behavior.  I'll try to find the article.

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Wednesday, January 28, 2004 1:07 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Error 2468 - You can't carry out this action at the
present time.

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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com