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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NCC240
    New Member
    • Nov 2011
    • 1

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

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

    Else
    Me.user_id = Forms!Login!txt MYID
    Me.assistance_i d = 3
    Me.date_resolve d = Null

    RunCommand acCmdRefresh
    DoCmd.RunComman d acCmdSaveRecord

    insAppealid = Me.appeal_id
    insdate = Me.date_complai nt_filed

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


    End If

    Exit_cmdworkapp eal_Click:
    Exit Sub

    Err_cmdworkappe al_Click:
    MsgBox Err.Description
    Resume Exit_cmdworkapp eal_Click
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    I don't know what the problem is.

    Comment

    Working...