[AccessD] Delete button on continuous form

 Hi David,

Been a while since I've used Access forms but I suspect the edit caused
by the type change
needs to be saved before you delete.  Why do you want to edit and then
delete?  ;-)))
Try docmd.saverecord   or something like that after the edit????

cheers

Michael M

www.ddisolutions.com.au


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David &
Joanne Gould
Sent: Tuesday, 15 November 2005 12: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