Updating Record Sets (2002 sp3)

Topic

New Reply

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,

Reply | Quote

Replies

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.

Reply | Quote

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,

Reply | Quote