update child row(s) when process/save main form..

N

nycdon

I'm looking to update row(s) in child subform (decreasing a count field by
1), when 'save' button clicked on Parent form.

What might be best strategy?

Thanks!
Don
 
K

Klatuu

Look at the Orders form and subform in Northwind.mdb. It has a great example
of how to handle that situation.
 
K

Klatuu

I think I misread your original post. Can you post more detail about your
problem. Is this count field a field in your table, a control on your
subform, or both? How does it get set originally?
 
N

nycdon

Sure, and thanks. It's basically a simple cash payroll system, with parent
form to put in hours, vacation, sick, etc. Currently uneditable Subform
brings in ongoing adjustments,say $100 deduction for 3 pay periods. I'd like
the 3 (and any other adjustment rows for that person) to get decremented to 2
when 'Save' button on parent form clicked and payroll for that person
completed.
Thanks again!
Don
 
N

nycdon

Yeah, the subform is uneditable, so was looking to update the data rows
themselves.
Think I figured out..i put in an Update query in 'Save' button vba code to
update rows where keys equal to parent form/rows.
 
Top