Complex issue in MS access

[ganeshvenkatram]

Hi All,

Im doing a project in access which i have created tables, forms and reports i have applied user secuity in my project.some users have editable permissions and some doesnt have.
In my form i have two fields which will capture system date & time as start time and end time.
start time will capture the time when the user starts keyin and the end time will capture the time after the record has been inserted in the table.

My problem is for non-editable permission users,the end time is not storing the time after inserting record since it will capture only after insertion and it goes to update state for whom doesnt have update permissions.

Hence i need code to capture and store the end time after the users filling all fields and before insert in to table.

Hope you guys got my problem. Plz provide me a solution.

[pike]

Welcome to the forum but,
Please take a few minutes to read the forum rules, and then amend your thread title accordingly.