previous record from new record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: max (a_at_b.net)
Date: 05/09/04 

Date: Sun, 09 May 2004 17:31:34 GMT

Hi all,
I really do not have a clue why I get an error in the following situation.

I have this code associated to a cmd button on a form, to move to the
previous record:
------------------ start of code --------------------------
Private Sub cmdUndoNew_Click()
On Error GoTo Err_cmdUndoNew_Click

    DoCmd.RunCommand acCmdRecordsGoToPrevious
    medNum.SetFocus

Exit_cmdUndoNew_Click:
    Exit Sub

Err_cmdUndoNew_Click:
    MsgBox Err.Description
    Resume Exit_cmdUndoNew_Click

End Sub
------------------ end of code -------------------------
this button appears when the recordset moves to a new record. Normally
pressing this button, provided that nothing has been written in the new
record (otherwise the button automatically disappear), the recordset moves
to the previuos record, the last of the recordset, canceling the new record
that was going to be filled in.
This button works perfectly using the form normally, while it gives the
error "the command or action CmdRecordsGoToPrevious isn't available now".
Does anybody have an idea why this is happening?

many thanks
Max

Relevant Pages

  • Re: previous record from new record
    ... >I really do not have a clue why I get an error in the following situation. ... >I have this code associated to a cmd button on a form, ... > Exit Sub ... >to the previuos record, the last of the recordset, canceling the new record ...
    (microsoft.public.access.formscoding)
  • Re: Why Cant I Delete a record this way?
    ... DataAdapter and configure the CommandText of the various sub command objects ... > Dim dsChanged As New Data.DataSet ... > Dim cmdStr As String ... > Dim Cmd As New OleDb.OleDbCommand ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problem with ADO in VB6
    ... If cmbName1.ListIndex < 0 Then Exit Sub ... Dim cmd As ADODB.Command ... Set cnn = New ADODB.Connection ... Set rst = New ADODB.Recordset ...
    (comp.lang.basic.visual.misc)
  • Re: Table in a form
    ... I would like to create a cmd button the will that will show the details of ... query. ... > specific query as its record set. ... > Private Sub cmdW2K_MouseDown(Button As Integer, Shift As Integer, X As ...
    (microsoft.public.access.forms)
  • Re: MS Access 2002: Go to newly added record from form2 to form 1
    ... for the onclick event of a cmd button. ... 'Dim rs As DAO.Recordset ... You don't say what the error is, but if a sub may generate an error then you ... Dim lngQID As Long ...
    (comp.databases.ms-access)