Re: Next & Previous buttons don't display data correctly in Access

Bruce,

I have read my notes and thought that clarification may be needed - my form
has BOTH the default Next & Previous Buttons (the ones showing next to the
record counter) and custom buttons. It is the Standard default ones that dont
work - the custom ones DO work ok.

Appologies for any confusion caused.

"C. Stanton" wrote:

> Bruce,
>
> I have inherited a small system that was designed by someone who left no
> documentation and is no longer contactable.
> The data that is displayed incorrectly is either shown as a null field or
> the value last entered in that field on the screen is shown (i.e. if a new
> was created or record was changed, then whatever was last entered on the
> screen on the form in this field, then this value is displayed for all
> records). NOTE - it is only display that is incorrect - the database remains
> correct. All fields concerned are Unbound fields that exist on other tables,
> except one field that exists on the table the form is based upon and is
> displayed as a combo box.
>
> The custom ''previous record'' button has the following code :-
>
> Private Sub cmdcalldetailprevious_Click()
> On Error GoTo Err_cmdcalldetailprevious_Click
>
>
> DoCmd.GoToRecord , , acPrevious
> Me.Refresh
>
> Exit_cmdcalldetailprevious_Click:
> Exit Sub
>
> Err_cmdcalldetailprevious_Click:
> Select Case Err.Number
> Case Is = 2105
> Exit Sub
> Case Else
> MsgBox Err.Description
> Resume Exit_cmdcalldetailprevious_Click
> End Select
> End Sub
>
>
>
> The ''Next Button'' is exactly the same except that word previous is
> replaced with the word next.
>
> The custom print button is supposed to print of a report version of the form
> where the code is as follows :-
>
>
> Private Sub cmdPrintCallDetail_Click()
> On Error GoTo Err_cmdPrintCallDetail_Click
>
> Dim stDocName As String
>
> stDocName = "rptCallDetails"
> DoCmd.OpenReport stDocName, acViewPreview, , "[ID]=[Forms]![frmMain]![ID]"
>
> Exit_cmdPrintCallDetail_Click:
> Exit Sub
>
> Err_cmdPrintCallDetail_Click:
> MsgBox Err.Description
> Resume Exit_cmdPrintCallDetail_Click
>
> End Sub
>
>
> Would I be correct in thinking thta if the Form error is resolved, this
> would then be reflected in the print function too?
> FYI - if I take the Print Function from the tool bar then every record is
> printed, and again the fields mentioned before are incorrect.
>
> I hope this answers all your questions and provides more clarification to my
> problem.
>
> Your help is greatly appreciated,
>
> regards,
>
> C. Stanton
>
>
> "BruceM" wrote:
>
> > Are you referring to the record navigation buttons at the bottom of the form
> > next to the record counter? In what way is the data incorrect? What is the
> > code behind the custom buttons? Did you use a wizard to create the Print
> > button? What does it do, and what are you expecting instead? What is the
> > code behind the Print button?
> >
> > "C. Stanton" <C. Stanton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:AA7E5073-C8C8-4677-BFDA-C0F962B13403@xxxxxxxxxxxxxxxx
> > > The default Next & Previous Butttons do not retrieve the data correctly
> > > from
> > > an Access database - this is also true of the Print Button functionality.
> > > However, the default buttons are not used but custom ones are added, the
> > > data is displayed correctly.
> > > I am unable to find how corect the default buttons.
> >
> >
> >
.