By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

I am having trouble with INSERT INTO creating a new record into a different table.

P: 1
If Me.user_id > "" Then
Response = MsgBox("This Appeal has been assigned to another analyst.", vbOKOnly)

Else
Me.user_id = Forms!Login!txtMYID
Me.assistance_id = 3
Me.date_resolved = Null

RunCommand acCmdRefresh
DoCmd.RunCommand acCmdSaveRecord

insAppealid = Me.appeal_id
insdate = Me.date_complaint_filed

strSQL = "INSERT INTO [Plan_Details] ([Appeal_ID],[Recon_Timely],[Effectuation_Timely],[Received_Date]) VALUES ('" & insAppealid & "','" & 0 & "','" & 0 & "','" & insdate & "');"


End If

Exit_cmdworkappeal_Click:
Exit Sub

Err_cmdworkappeal_Click:
MsgBox Err.Description
Resume Exit_cmdworkappeal_Click
Nov 23 '11 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
I don't know what the problem is.
Nov 23 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.