disable auto upate on bound controls

[jebushatescats]

Hello all
I have a subform, that is a continous form, containing controls that are bound to a table.
I want to be able to disable the auto update so that the user can add/delete/alter records on the form and not have the changes take effect uptil they leave the form
Can I disable the auto update?

 

[ProgramError]

Try making the fields unbound and use a append or update SQL to add them to the table.


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.