I have a main/sub form that was created to allow users to rapidly change certain fields (combo boxes). The form is in datasheet view to facilitate ease of record modification.
As there could be hundreds of records that the user may be modifying, I do not want Access to save each record as its Focus is lost. Is there a way to delay saving until the User clicks a Save button or, at least, can I create some function that prompts the user to save (could choose not to)?
I would appreciate any feedback that you may have.
Thank you.
As there could be hundreds of records that the user may be modifying, I do not want Access to save each record as its Focus is lost. Is there a way to delay saving until the User clicks a Save button or, at least, can I create some function that prompts the user to save (could choose not to)?
I would appreciate any feedback that you may have.
Thank you.
