Delete Multiple Records from Subform

B

BrianDP

I have a subform attached to a form, and when you select more than one
record and try to delete, Access hangs, and finally comes back with an
ODBC Error. The backend is a MS SQL database.

Help!
 
B

BrianDP

I have a subform attached to a form, and when you select more than one
record and try to delete, Access hangs, and finally comes back with an
ODBC Error.  The backend is a MS SQL database.

Help!
Click to expand...

It seems like there is some code behind the subform - so every delete,
before delete, before confirm delete, after confirm delete, they all
run the same sub-routine.. I don't know what the subroutine does yet,
but when I took out the references to the subroutine from the delete
events, it deleted the records no questions..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete record error form / subform 1
Subform with no records 8
Testing Subform Records to make button visible 1
Subform with subform properties 0
Access Main form/Subform Navigation 0
must have 2 records in subform 9
Display Child Records in subform 7
First Subform record gets modified when closing form 3

Top