Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Norway
    Posts
    239

    Question Unanswered: Record number in Continuous Forms.

    Is it possible, via VB, to retrieve the record number displayed when using the vertical scroll bar in a continuous form?

    Thanks for any advice

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You can get the current record # with: Me.CurrentRecord

    This may or may not be the ACTUAL physical record # depending on sort orders and how the data was read in ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2002
    Location
    Norway
    Posts
    239

    Question

    This was not exactly what I had in mind.
    The number I see when I use the vertical scroll bar is another one than what's displayed using Me.CurrentRecord. Me.CurrentRecord is updated when the record got the focus.
    The number I'm looking for updates when using the vertical scroll bar.

    By the way, is it possible to determine if the vertical scroll bar is used.

    Thanks for your input.

Posting Permissions

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