Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts
    In Access 2003

    How do I know when a user has moved to another record on a continuous form. I am sure it must have to do with a lost focus event but since it could happen from many controls I am not sure where/how to know it has happened. Equally I need to know when a user has gone back to a previous record (not necessarily to the first control for the record.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    The OnCurrent event of the form happens whenever a user has moved to a different record.

    Previous implies an order.
    So you could use the OnCurrent event to capture (in a module level variable) the current value of the field that is the basis of the order. Before assigning the vale to the variable, you could compare the current value with the variable value (set in the previous firing of Oncurrent) (if it has a value) and see if it is smaller or larger.

    ps: I don't see any connection between your question, and the thread title "Changing Control Properties". Makes me wonder if I am missing the point.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Delta, Br. Columbia
    Posts
    116
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you John for the info. I suspected it was something like the on current event but was not sure when it occurred. The confusion over the thread title is because I was thinking about what I have to have happen when the user moves to another record. This involves changing the locked property of various controls depending upon a value in one of the fields of the record.

Posting Permissions

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