Results 1 to 3 of 3
  1. #1
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70

    list box issues, main form on current not triggering

    i have list box which lists all active records. raw source is based from Main Query which lists all active records from current user. on click even of list box i have macro that goes on record selected in list box, which is working fine.


    on current event of main form function is called.

    Main Query order by id Desc, list box order by is Asc

    problem is when i click on last field in List Box which takes me to record, On Current event does not trigger on main form. if i use Record Selector on main form to go to that same record,On Current triggers.
    any ideas?

  2. #2
    msoffice.vidyarthi is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Nov 2012
    Posts
    24
    sample file would help to analyse the problem

  3. #3
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70
    i figured it out.
    i had table with records. from that table i made query to pull only related records and order by ID DESC. from that query i made a form.
    problem i encountered was that whenever i try to go to last record on table (first record in query) the form would go to that record by On Current event was not firing. must be some kind of glitch but i fixed it by setting Query order by ID ASC

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-13-2012, 02:11 PM
  2. Triggering a form event from a report
    By Paul H in forum Forms
    Replies: 2
    Last Post: 10-12-2012, 09:48 AM
  3. Replies: 2
    Last Post: 01-17-2012, 01:17 PM
  4. Replies: 2
    Last Post: 05-11-2011, 02:58 PM
  5. Replies: 1
    Last Post: 01-06-2010, 10:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums