Updating many records in datasheet subform

[emphyda]

Hi all,
I am trying to build a sales invoice for a pharmacy that contains a sub form in a datasheet view. The main form contains only the invoice number and date while the sub form contains the drug code, drug name, Qty., Available Qty. and Updated Qty.
Presently, I can only code the update to takes place on each line of the datasheet. I want the update to take place at the end when I must have finished inputting all drugs bought with same invoice number.
Please I try as much not to include too many VBs.
Who can help me.
Thanks
Emphyda

 

[billmeye]

What is it that you are updating on the subform? You might be able to use an Update Query.

 

[emphyda]

I am updating the available Qty.
My datasheet sub form has many line of drugs purchased with just one invoice. Presently, I was able to put up a query that updates each line. What I want is if I have say 10 lines at a time, I want to update them once.

 

[JHB]

How are you updating the one record and from where?
Show your sql-string.