You could provide a button on the form that closes it without saving design
Private Sub cmdClose_Click()
'Save record changes.
If Me.Dirty Then
Me.Dirty = False
'Close without saving design changes.
DoCmd.Close acForm, Me.Name, acSaveNo
The real solution, though is going to be to split the database so that each
user has their own copy of the front end, and you avoid the concurrency
issues. There is a database splitter in Access. More info:
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/