create and last modify date & time for record

[msasan1367]

how can I add create and last modify date & time to my table

[June7]

Question doesn't make sense. Give a better explanation of what you need.

[msasan1367]

Question doesn't make sense. Give a better explanation of what you need.

Example:
table for customers [name, family, mobile, createDate, createTime, modifyDate, modifyTime]

when I create new customer, automatically fill createDate and createTime records with date and time
when I modify customer information, automatically fill modifyDate and modifyTime records with date and time

[June7]

You can set DefaultVaue property in table or textbox on form with: Date()

[msasan1367]

You can set DefaultVaue property in table or textbox on form with: Date()

what do I do for modify Date?

[June7]

Need VBA code.

How is the program to know that you opened the record to 'modify' and not just to look at? Are you modifying data in name, family, mobile?

Maybe code in the form BeforeUpdate event?

Me!modifyDate = Date()

Why not one field for date/time?