Results 1 to 6 of 6

Thread: subform event

  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    subform event

    I have a subform in datasheet view.
    When I click to the left of a row, the entire row is highlighted.

    What is the name of the event that tells me that a row has been highlighted?

    TIA
    Donald

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform event

    To my knowledge, there is not a specific event that fires when a row is highlighted (at least not in Access 97/2000). You could probably use a combination of the Click and CurrentRecord events to accomplish your purpose. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: subform event

    The highlighting is incidental. It's just to show you that you've selected that record. What is it you want to do when the record is selected?
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform event

    Two things:
    1. Open another form with all the details of the record for editing.
    2. Return to that line in the subform after completing work in the detail form.

    Donald

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform event

    I've done something similar using a continuous form sized to look similar to a datasheet view. However, I placed a small button in the detail section that opened another form to the selected record.

    Post back if you need more details on how to accomplish this.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  6. #6
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform event

    I've used the double click event of the form to open another form with the selected record. You could also use the click event.

Posting Permissions

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