G
Guest
I have a temporary table which after one enters information, they push a
button which is suppose to run a query to move the data to a permanent table,
delete the record from the temp table, and then refresh the form - but my
form shows #Deleted in all the fields and I can't figure out what else to
do. I need the temp table in order to find a next number. Here's the code on
my button to move, delete & refresh the form. Thanks in advance for the
help!!! Jani
Private Sub cmdSaveThisRecord_Click()
On Error GoTo Err_cmdSaveThisRecord_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
stDocName = "macTempDataToSQl"
DoCmd.RunMacro stDocName
Me.Refresh
Exit_cmdSaveThisRecord_Click:
Exit Sub
Err_cmdSaveThisRecord_Click:
MsgBox Err.Description
Resume Exit_cmdSaveThisRecord_Click
End Sub
button which is suppose to run a query to move the data to a permanent table,
delete the record from the temp table, and then refresh the form - but my
form shows #Deleted in all the fields and I can't figure out what else to
do. I need the temp table in order to find a next number. Here's the code on
my button to move, delete & refresh the form. Thanks in advance for the
help!!! Jani
Private Sub cmdSaveThisRecord_Click()
On Error GoTo Err_cmdSaveThisRecord_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
stDocName = "macTempDataToSQl"
DoCmd.RunMacro stDocName
Me.Refresh
Exit_cmdSaveThisRecord_Click:
Exit Sub
Err_cmdSaveThisRecord_Click:
MsgBox Err.Description
Resume Exit_cmdSaveThisRecord_Click
End Sub