Results 1 to 6 of 6

Thread: Selected row in Access subform datasheet? [resolved]

Threaded View

  1. Nov 14th, 2003, 09:28 AM #1
    DaveBo
    DaveBo is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2001
    Location
    N42 29.340 W71 53.215
    Posts
    422

    Question Selected row in Access subform datasheet? [resolved]

    I have a datasheet subform on an Access form and I want to allow the user to select a record via the record selector column at the far left, and then I'll process that in VBA code.

    The problem is:
    in the form_click event I can get Me.CurrentRecord OK and run with that,
    BUT, clicking on a column header also fires this event and always returns CurrentRecord=1
    and I can't figure out how to differentiate between actually selecting row 1 and clicking on a column header.

    Any ideas? Thanks, DaveBo
    Last edited by DaveBo; Nov 18th, 2003 at 11:30 AM.
    "The wise man doesn't know all the answers, but he knows where to find them."
    VBForums is one place, but for the really important stuff ... here's a clue 1Tim3:15
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width