Results 1 to 8 of 8

Thread: Mind gone blank

  1. #1
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Red face Unanswered: Mind gone blank

    (Access 2000)

    I have a form which displays single records.

    If the user selects a record from the dropdown in the header, I run some code. (Trapped on the afterupdate event of the dropdown)

    I also want to run the same code if the user goes to another record by clicking the standard record navigation buttons at the bottom of the screen.

    Can't remember how or where to trap for this event?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  2. #2
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    139
    As far as I know you have to create your own button controls to move from one record to another and run the code. You can even hide the navigation buttons looking into the form properties, so the user must use 'your' buttons. That's what I did...
    Marco
    ---Do not send e-mail---
    "New Big Bang Theory: God said unzip universe"

  3. #3
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Thanks

    Thought so....anyone got a better idea, let me know
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  4. #4
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Try using the "on current" form event - which traps navigation to a different record.

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Wouldn't it be nice if Access had a "BeforeLeaveRecord" event for the form!
    Inspiration Through Fermentation

  6. #6
    Join Date
    Jul 2003
    Location
    Italy
    Posts
    139
    I can't remember why, but the 'on current' event gave some problem. I would probably prefer RedNeckGeek solution, if it only exists!
    Marco
    ---Do not send e-mail---
    "New Big Bang Theory: God said unzip universe"

  7. #7
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Talking My mistake

    Tried on current but was referencing the wrong variable on my form.

    Thanks for the reminder!
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  8. #8
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179

    Thumbs up

    Originally posted by RedNeckGeek
    Wouldn't it be nice if Access had a "BeforeLeaveRecord" event for the form!
    YES

    * makes note to remind "uncle willy" how helpful this would be *

Posting Permissions

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