need a bit of help with recordsets ....

[Guest_imported]

I'm trying to, with the click of a button, to update a field [productQuantity] in table products, with the related data [productQuantity] from the orderDetails table; following inputting an order. I assume this will involve recordsets, which I am struggling with. Haven't even figured out what the book is trying to say....difference between ADO and DAO ....god I'm lost.

What's the best way to tackle this. Thanks in advance.

 

[scotthellewell]

If all you want to do is update a record then look at using a simple sql statement such as

docmd.runsql "Update tblWhatever Set fldWhatever = 'value' where fldWhereever = 'value'"

This will update flwhatever to 'value if fldwherever = 'value' sql statements often times run much faster than opening/closing and updating recordsets and are a lot easier to use.

Scott Hellewell