Updating Fields on a Subform from Main Form

[CBenfer]

Hey all. I'm back again.

I have a main form and subform set up where the main form shows a work order and the subform allows the operator to enter various materials required.

I'd like to set up a button to print up a purchase order for all of the items entered, then set the "order date" for each to the current date.

I tried to add a standard "print report" button and insert:

Me![MaterialOrdersTbl subform].Form!OrderedDate = Now

after the print report call. It works (sort of) - but it only updates the first record in the subform.

I tried setting up a separate button with the above statement as the ONLY command and it works perfectly. Any ideas?

Thanks in advance.

 

[CBenfer]

OK - I lied. I apparently didn't test the other button well enough. Sometimes it seems to update all of the records, other times only the one I had most recently selected. So both buttons don't work (which makes me feel a little better), but I still don't know if there's a good way to do what I want.

Let me know what you all think.