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

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanks - i took look, but didn't see any code that updates rows on subforms..

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

If the subform is uneditable, I don't know how you would be able to do this.

 

[Guest]

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.