Records being deleted

[RikkiHolland]

Hi

I have an access database being used to capture job roles. It is set up with a front end Access Database which users use to create job roles, which are then stored in a back end Access Database. These records are then amended on going via the front end.



I've recently found that certain data is being lost or changed, predominately dates, but no VBA code has been changed. Does anyone have any ideas what I should look out for that could be forcing changes in the records being saved?

Any help greatly appreciated.

[ranman256]

Users can delete records if the form allows it.
or modify.
but if they are NOT removing dates,and it IS happening, then see if the field is connected to the form textbox.
add a check in the leave record event to make sure the date IS there, and not skipped.