Advertisement

10.22.2007 at 07:00AM PDT, ID: 22908995
[x]
Attachment Details

"Access 2007"  Me.RecordSet.Delete and refreshing the current form question.

Asked by SheahaST in Access Coding/Macros, Access Forms

Tags: access, delete, record, form, 2007

I have a button on a form that will delete the current parent record via Me.RecordSet.Delete.  This parent form has 5 subforms.  Each subform is displaying a record associated with the parent record via referential integrity and "Cascade Delete Related Records".  When I press the delete button the information displayed from the parent record is still displayed, but the information in the subforms is not.  When I navigate to the next record in the parent form, I get the message "Record is deleted".  Hitting OK, I get the next record.  Navigating to the previous record the deleted record is no longer displayed.

My question:  How do I refresh the form so after I delete the current record I no longer see its remanents and need to navigate to the next record?  Also I do not want to see the "Record is deleted" message.

Thanks, SteveStart Free Trial
[+][-]10.22.2007 at 07:24AM PDT, ID: 20123352

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.22.2007 at 09:36AM PDT, ID: 20124508

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.22.2007 at 11:53AM PDT, ID: 20125753

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.22.2007 at 08:52PM PDT, ID: 20128554

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.23.2007 at 04:07AM PDT, ID: 20129908

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.23.2007 at 05:49AM PDT, ID: 20130483

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.27.2007 at 12:28AM PDT, ID: 20160715

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Access Forms
Tags: access, delete, record, form, 2007
Sign Up Now!
Solution Provided By: peter57r
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628