<div>
Hi <br />
<br />
What is the form's recordsource at the time of the delete? <br />
<br />

</div>


Hi

What is the form's recordsource at the time of the delete?



<div>
It's a query having about 7 tables. Table Header is one of those tables.
</div>


It's a query having about 7 tables. Table Header is one of those tables.

<div>
This question must have slipped through the EE cracks. I had never received a notice saying it was still open. I figured this one out a long time ago.
</div>


This question must have slipped through the EE cracks. I had never received a notice saying it was still open. I figured this one out a long time ago.

<div>
<div class="content wysiwyg-content">
I have a user receiving a message that I don't get. They get run-time error 3167: Record is deleted. It happens when clicking on a button that is to delete a record from a table that is part of the query for the form.<br />
<br />
Here's the code:<br />
<br />
CurrentDb.Execute &quot;DELETE * FROM Header WHERE AssessmentID=&quot; &amp;&nbsp;Me.AssessmentID<br />
Me.Form.Requery<br />
<br />
Is this caused because of the requery? Maybe the form doesn't know the record has been deleted.
</div>
</div>


I have a user receiving a message that I don't get. They get run-time error 3167: Record is deleted. It happens when clicking on a button that is to delete a record from a table that is part of the query for the form.

Here's the code:

CurrentDb.Execute "DELETE * FROM Header WHERE AssessmentID=" & Me.AssessmentID
Me.Form.Requery

Is this caused because of the requery? Maybe the form doesn't know the record has been deleted.

Run-time error 3167: Record is deleted

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.