Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts
    This has to be an easy question but I just can't find the answer...
    I need to hide some columns of a subform based on the value of a field on the parent form. I have a change event on the parent form field to hide the columns which works fine when the user changes the value of the field but if the user scrolls through or navigates to another record the change event of the field doesn't fire and the column remains hidden (or not) regardless of the value of the parent form field. Is there an event for the parent form that I can use to capture the scroll or navigation? I tried "After Update" and "On Data Change" but they didn't do it. Is there a better approach for this?
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Use the On Current event of the parent form. This event occurs each time the user (or code) moves to a different record.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank You! I wouldn't have thought of that one.
    Thanks

Posting Permissions

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