Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update a read-only recordset (A2003)

    Main form contains a subform (datasheet view) that is based on a read-only recordset. A new requirement has added another field to the recordset that must be updated by the user. The field values will always be 0, 1, 2, or 3. I was hoping to allow the user to select an arbitrary number of records in the subform to be updated, then perform some action (click a button, select from a combo box, select a radio button, etc) that would update the underlying table via VBA. But I can't figure out how to do that...

    Any suggestions?
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update a read-only recordset (A2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Found a method:
    http://groups.google.com/group/microsoft.p...a68ea933e442655
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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