Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Unanswered: Access 2000 forms record count won't show

    I have a SQL Server 2000 backend with an Access 2000 .mdb frontend using ODBC to connect to the SQL tables.

    I have forms with their Recordsource set to the SQL tables but when I open the forms, the total record count isn't shown beside the record navigator unless I click to go to the end of the recordset. I really need the record count to show up.

    HELP!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    This question really belongs in the Acces forum, but try creating an On Open event in your form with this code:

    Private Sub Form_Open(Cancel As Integer)
    DoCmd.GoToRecord , , acLast
    DoCmd.GoToRecord , , acFirst
    End Sub

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •