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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Look at the Orders form and subform in Northwind.mdb. It has a great example
of how to handle that situation.
 
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?
 
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
 
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.
 
Back
Top