<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
<br />
<br />
I need the Access form and when you click the&quot;YES&quot; I need to have the one RECORD to transfer the reocrd into a different table and Delete in the present table. Just the Record you are on. &nbsp;Is this possible?<br />
'/////////////////////////<wbr />//////////<wbr />///<br />
Private Sub cmdTransferToTable1_Click(<wbr />)<br />
Dim iResponse As Integer<br />
<br />
&nbsp; iResponse = MsgBox(&quot;Are You Sure?&quot;, vbYesNoCancel, &quot;Processing&quot;)<br />
<br />
&nbsp; Select Case iResponse<br />
&nbsp; <br />
&nbsp; &nbsp; Case vbYes<br />
<br />
'//////////////////<br />
<br />
Any help would greatly be appreciate!!<br />
<br />
<br />

</div>
</div>




I need the Access form and when you click the"YES" I need to have the one RECORD to transfer the reocrd into a different table and Delete in the present table. Just the Record you are on.  Is this possible?
'//////////////////////////////////////
Private Sub cmdTransferToTable1_Click()
Dim iResponse As Integer

  iResponse = MsgBox("Are You Sure?", vbYesNoCancel, "Processing")

  Select Case iResponse
  
    Case vbYes

'//////////////////

Any help would greatly be appreciate!!




Transfer One Record into New Table and Delete in Old Table

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.