Prevent Date/Time generate more than once

ohio

Registered User.
Local time
Today, 04:05
Joined
Dec 20, 2000
Messages
13
I am creating a Call log program, in the call log form i have 2 fields which are date log and time log which generated from the system. How to lock the date/time in order to prevent the date/time overwrite the previous one when the particular call log form opened at second time. What i mean that i only want the particular call log generate the date/time once only which is the first time the call log created.

Pls help.
 
Add a default value to the columns in table design mode and remove the form code that is setting the setting the values currently. Or, move the form's code to the BeforeInsert event.
 

Users who are viewing this thread

Back
Top Bottom