Recordset Question

[amerfeld]

I have a quote form with many subforms. The subform's recordsource is a pricing table. I have a procedure that copies the quote and updates pricing where applicable using a recordset (edit, update). All is good with that part.

Here's the issue: If I close and set the rs to nothing at the end of the procedure, then there is no data in the form fields (the table is updated). If I don't close or set the rs to nothing after the updates all is good. However, I know I need to close and set rs to nothing.

My question: Can I fake out access and reset the rs at the close of the main form to allow me to release the rs? Do I need to reset the recordsource of the form before exiting the procedure and how would this be done? Or what would be a better way of handling this whole thing? I will need to do this same thing on several other subforms.

Any help appreciated.

 

[Mile-O]

I have a quote form with many subforms. The subform's recordsource is a pricing table. I have a procedure that copies the quote and updates pricing where applicable using a recordset (edit, update). All is good with that part.

What happens when you want to view something with historical prices?

 

[amerfeld]

There is no need to view historical pricing. We are creating an entirely new quote. Copying the original pricing (and the quote information) just saves the user from having to reenter much of the same information. If our charges have changed from the original quote, they will be updated. This is where I use the recordset. Thanks.