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...