Hi,
I have a subform that is linked to a query and displays the results.
I wrote some code that will allow the user to copy all the records. Before they copy, I need to allow them to modify any data on the subform.
Everything works well until the form gets closed. It updates the original record but I can't let that happen.
Is there a way to allow a user to edit a record but not allow the form to update it??? Can the update be suppressed?
Thanks,
Mark
I have a subform that is linked to a query and displays the results.
I wrote some code that will allow the user to copy all the records. Before they copy, I need to allow them to modify any data on the subform.
Everything works well until the form gets closed. It updates the original record but I can't let that happen.
Is there a way to allow a user to edit a record but not allow the form to update it??? Can the update be suppressed?
Thanks,
Mark