[AccessD] Delete button on continuous form

Thanks, Dan

It worked perfectly.

David

At 01:54 PM 15/11/2005, you wrote:
>David,
>
>In the code behind the Delete button, try inserting the code:
>
>         Me.Undo
>
>Before the actual delete code.  This will get rid of the unsaved changes
>which might be causing your error message.
>
>Dan Waters
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David & Joanne
>Gould
>Sent: Monday, November 14, 2005 7:56 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Delete button on continuous form
>
>I am working on a database for a video library. The hire form has a
>continuous form that has a delete button on each row. The users can also
>double-click on the combo box for selecting the movie title to change the
>rental type (eg overnight to weekly, etc). This is what causes the problem.
>The delete button was created using the wizard. If the user hasn't change
>the rental type then the delete button works fine. If they have they will
>get a message "Write conflict" telling them that another user has made
>changes to the record. They then have three choices:
>
>Save record: This gets the message "The record cannot be deleted or changed
>because 'tblHires' includes related records"
>Copy to Clipboard: This gets the message "No Current record" and then
>deletes the details as I wanted
>Drop Changes: This does the same thing as the Copy to Clipboard option.
>
>I believe I either need to make a change to the code used to change the
>Rental type (probably the right way to fix it) or find a way to suppress
>the error message when I am deleting so the user isn't bothered by it. I
>have tried turning warnings off but it made no difference.
>
>TIA
>
>David Gould
>DG Solutions
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com