Need help changing a line of vb code

[Rob]

Our programmer is on vacation for a couple of weeks and I can't wait that
long to fix it.

This should be as simple as changing one line of vb code from
ProductAvailability to PackQuantity and I was hoping someone could tell me
where to find that in my file so I can make that change. Because of this
glitch (my fault I told programmer to update using the wrong field) i really
messed up some stuff.

The problem exactly is a field in the mdb CaseQty is being updated by the
wrong field in the xml
It is updating from
<SupplyDetail>
<ProductAvailability>40</ProductAvailability>
</SupplyDetail>

But it is supposed to be updated with

<SupplyDetail>
<PackQuantity>16</PackQuantity>
</SupplyDetail>


Thanks a lot.
Source file is located here. It is access 2002 I believe.

www.buggyonpurpose.com/random/UpdateProductWeight.zip

 

[Guest]

There is reference to an XML Tag labelled "ProductAvailability", and
associated to CaseQty, in the tblAdmin table. However, there appears to be
no reference to any factor similar to "40"

*Do the following at your own risk*

You could attempt to change the value of XML_UpdgateTag, on record w/
AdminID 10, to "PackQty" (or whatever the correct name is).

This may or may not be successful, and I accept no responsibility for this
suggestion.

 

[Rob]

The values 40 and 16 were just example values for the fields PackQty and
ProductAvailability.

I'll give that a try.

 

[Rob]

Oops, almost forgot. Thanks, Sharkbyte! That was the place to change it