Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Record Sets (2002 sp3)

    I need help using record sets to update a table base on information the user has input to a form. I am not sure this is the best approach to doing this either. I have search the lounge and found some examples and was trying to adapt those to my situation. I have so far been unsuccessful.

    I think the tricky part will be when there will be several records that will be updated based on a single entry into the form. Example, when a parent part is produced it takes several child parts to make that one part. I would like to show that those child parts taken out of inventory.

    Some child parts are produced in-house, so when those parts are made have it added back into the current inventory of child parts as well.

    I have attached a sample of what I was trying to accomplish.

    Any input and help would be much appreciated.

    Thank You,
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Updating Record Sets (2002 sp3)

    Do you want the qty entered on the form to be taken off each of the applicable tbl_child_ohi records.

    Look at Parent1 which has 3 cheild records in the tbl_child_ohi table, do you want the qty on the form to be subtracted from each of these Parent1 records.

    If so, simply make a do loop after the Set Rs command.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Record Sets (2002 sp3)

    Thanks, I am new at using Record Sets in code. I added the loop and had an error in my strSQL. I had put the wrong table for the qtyper field in my SELECT clause. Everything works perfect.

    Thanks again,

Posting Permissions

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