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

    Which row is it?

    I have a form with 2 comboboxes and 2 textboxes. Based on the entries in these four controls I dynamically build an SQL statement to populate an ADO recordset and display the results on a subform in datasheet view. When I click to the left of a row in the subform, the entire row is highlighted and I use the subform_click event to enable an Edit command button.

    All that works fine. Now, I want to edit the record that was selected.

    What is the property that tells me which row in the subform has been highlighted?

    Thanks
    Donald

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

    Re: Which row is it?

    The record you selected is always the current record in the subform. All you have to do is refer to the controls on the subform to get the values for the currently selected record.
    Charlotte

Posting Permissions

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