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
Any help would greatly be appreciate!!