
March 17th, 2004, 07:01 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 9
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Tracking successful deletions on bound ADP forms
Problem Description:
MS KnowledgeBase Article 234866 (Order of Form Delete Events differs in ADPs & MDBs).
http://support.microsoft.com/defaul...Product=acc2000
MS KnowledgeBase Article 224333 (How to track successful Deletions on Bound ADP Forms).
http://support.microsoft.com/defaul...Product=acc2000
In the code supplied, in the Form.Open event, the rsADO recordset needs to be set to ME.recordset.
The problem I have is that this form is 'requeried' from a number of pop-up forms. At this point I assume I need to reset the rsADO recordset, but I don't know how to. I have changed the declaration from Private to Public in the main form, but I still get an error message "Object doesn't support this property or method".
Because there are pop-up forms, I don't know of an event in the main form where I can rest my rsADO.
can anyone suggest possible solutions?
|