Results 1 to 6 of 6
  1. #1
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200

    OnCurrent Event not firing when using Split Form

    I have a form that contains a tab control. I want the tab control caption to include the number of records in the datasheet within that tab. I coded this in the OnCurrent property on the form, so that the "dynamic caption" changes based on the current record on the main form. This all works..



    The problem is...If a type in the record number in the record selector or navigate with the record selector arrows, the dynamic caption reflects the current record count, etc. and it all works. But if I navigate to the record with the Split Form, the dynamic caption doesn't change. I thought the OnCurrent event always fires when you change records, but it apparantly isn't working when navigating with a split form. Anybody know of a workaround?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    By 'navigate to the record with the Split Form' do you mean just clicking record in the datasheet part of the split form? I just tested that and the Current event did run.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    Yes, that is what I am referring to.

    It is not doing that for me. If I use the record selectors on the bottom of the form, the caption on the tabs is refreshed. If I navigate by clicking split form record selectors, this doesn't happen.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Since I can't replicate the issue, do you want to provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    I'm not able too. Thanks for the help though.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Why not? Don't care about data, just structure. Make copy, remove confidential data, run Compact & Repair, zip if large, attach to post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Can I Force an OnCurrent Event?
    By bginhb in forum Forms
    Replies: 5
    Last Post: 12-23-2011, 06:28 PM
  2. Split form event error
    By witooldas in forum Forms
    Replies: 10
    Last Post: 03-24-2011, 03:15 AM
  3. Unselect listview items in OnCurrent event
    By majq in forum Programming
    Replies: 0
    Last Post: 02-21-2011, 07:51 AM
  4. Oncurrent event too fast?
    By Neutrino in forum Forms
    Replies: 24
    Last Post: 01-08-2011, 02:48 PM
  5. Form level mouseup event not firing
    By Philhoop in forum Forms
    Replies: 3
    Last Post: 07-22-2010, 09:41 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