Form record

[Jpernice]

hello


I have a form that pull from a query that multi record.
I would like to be able to enter a amount next to each record so it may calculate the net price.
these record do not need to be store or update any table they will change with new each vendor.




When i update the first record for that text box it update all record.

Customer price - rebate = net


Thanks
jon

[ranman256]

If you put a txtRebate box in the form header (not in the grid & not bound to A field) you could put a button in the header to run an update query to update ALL records with the value in the txtRebate box.