Prevent moving off the current record on a continuous form until it is saved

[LGrossman]

Hi all,

I have a continuous form and I want to stop someone clicking/moving to any of the other records displayed until the one they're in is saved.

Several of the fields in the record update another table on save and I want to stop people moving off the record they started until the update has been performed.

I hope that makes sense, any help would be appreciated.

[June7]

How do "several of the fields" update another table? Record is committed to table when moving to another record.

[LGrossman]

I use an update query to update the table when the user clicks the 'Save' Button.

[June7]

So do you have command to save record? Are users even able to move to another record before code completes execution?

[Micron]

Are these form controls bound to fields in a table or query? If they are, then as June7 says, you don't need a save button. If they're not, why use unbound controls and code, which only makes your job harder?

[LGrossman]

You're both right, I have sorted it now without a Save button using the 'Afterupdate' event in the control.

Thanks all.