Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculation in Form Field 1

Status
Not open for further replies.

hvns

Technical User
Oct 2, 2007
25
0
0
US
I have a form where the form field "Date Due to Customer" is populated - and I would like it to feed the next field "Date Due to Contracts" minus 1 day).

Both fields are in the same table and are of the short date property.

any help is greatly appreciated
 
In the AfterUpdate event, place this line:

Me("Date Due to Contracts")=Me("Date Due to Customer")-1



[pipe]
Daniel Vlas
Systems Consultant

 
tyvm - just what i needed, could you recommend some links or sites to help me further study up on using the event procedures / vb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top