Operating Over Subforms ?!!

[Aeon.Divine]

This is a hard one.

Is it possible to operate over a single field of a subform modifying every register field in the same way ?

Let say i have a form with a subform inside, lets also say my subform is a list of products in which we have certain fields including one named "unit price"

Would it be possible to modify every registry "unit price" field with a button placed in the form programmed to increase or decrease the prices (Lets say in a 5%) ???

[ If theres a way to reffer to whole fields of a subform in vb, that would be really awesome. ]

Thanks in Advance !!

 

[pbaldy]

An UPDATE query might work. Let's say

UPDATE TableName
SET FieldName = FieldName * .95

perhaps with a WHERE clause the restricted the records.

 

[Aeon.Divine]

Mm.. I dont think i get it, im not so used to working in access. Could you explain it a little more ?