Hello again 
Ok, so now I am at my final step. I seperated my database into two databases, one for transactions and the other for balances. A balance is first created, then when a new transaction is entered, it grabs the existing balance allowing the user to add or subtract the new quantity. Now here is the problem. How do I update the old balance with the new one?
I would really like a hotspot to perform this action, but I have no idea what @function could acheive this.
Thanks everyone!
-David
Subject: @Replace
Look at @Replace the value you want to replace with the new value.
Subject: RE: @Replace
How would I enter that exactly?
My current dblookup formula looks like this, is there a way to bring in @replace into this?
@If(Transitem=Null;Null;@DbLookup(“Notes”:“NoCache”;“”:“RichInventory.nsf”;“Quantities”;TransItem;5))
Subject: Updating old quantity with new
Here is some more imput on the form…
Currently there is a combobox (field1) that brings in a view from my other database. Then I have a field that brings in a specific quantity using @dblookup (field2)I then have a field for the new quantity (field3)that is used to imput the new amount being brought in or taken out. Finally my last field (field4) add’s field2 and field3 together.
I now want to change the quantity I got out using dblookup with the quantity in field4…
I hope this sums up a little for what I’m looking for.