Form and sub form last modified stamp

R

Robin

Hi All,

I have a main form and a sub form that my staff use for order entry. The
main form records the order header info and the sub form records the order
lines. I have added a last modifed date and time stamp to the header form
which works perfectly when i modify the header info but when i make changes
to the order lines in the sub form the stamp is not updated.

Can anyone suggest how i can make the stamp update when the order lines are
changed?

Thanx
 
S

strive4peace

Hi Robin,

in the BeforeUpdate event of (each of) your subform(s)...

me.DateModified_controlname = Now()
me.parent.DateModified_controlname = Now()

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
How do I clear a form? 0
Need help modifying code 0
Form doesn't move to next record after update 3
filtering a form based on the values of a subform 0
"No current record" after Quit in Form_Unload 3
Tabbing between a main form and a subform 1
How to Update a form: requery, recalc, refresh from subform entry 5

Top