I have created a form for entering a new JOB Details and Query purpose. Is there any way asking from user whether to update or cancel before update the tabel,if anyone change the detail while they querying it.
Many thanks if any one can help me on this.

You can use the BeforeUpdate event to fire if a recordset has been changed, this will fire before the data is written to the tables and will only fire if the data has changed

Sorry Frank I could not get working by event in the "before update". Could it be possible you to explain about fire?

Sorry Frank I could not get working by event in the "before update". Could it be possible you to explain about fire?