INSERT INTO #Request.prefix_db_agency#.Event ( EventSub_ID, Patient_ID, Employee_ID, Event_Date, Memo, Resolved, Agency_ID, who_observed, MD_notified, Was_observed, injury, Followup_desc, Followup_memo, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( '#Trim(form.EventSub_ID)#', '#Trim(form.Patient_ID)#', #form.Emp_ID##Session.EmployeeID#, #CreateODBCDate(form.Event_Date)#, '#Trim(form.Memo)#', '#Trim(form.Resolved)#', #session.AgencyID#, '#Trim(form.who_observed)#', '#Trim(form.MD_notified)#', '#Trim(form.Was_observed)#', '#Trim(form.injury)#', '#Trim(form.Followup_desc)#', '#Trim(form.Followup_memo)#', #CreateODBCDate(Now())#, #Session.EmployeeID#, #CreateODBCDate(Now())#, #Session.EmployeeID# ) UPDATE #Request.prefix_db_agency#.Event SET EventSub_ID = '#Trim(form.EventSub_ID)#', Patient_ID = '#Trim(form.Patient_ID)#', Employee_ID = '#Trim(form.Emp_ID)#', Event_Date = #CreateODBCDate(form.Event_Date)#, Memo = '#Trim(form.Memo)#', Resolved = '#form.Resolved#', who_observed = '#form.who_observed#', MD_notified = '#form.MD_notified#', Was_observed = '#form.Was_observed#', injury = '#form.injury#', Followup_desc = '#Trim(form.Followup_desc)#', Followup_memo = '#Trim(form.Followup_memo)#', Record_Mod_Date = #CreateODBCDate(Now())#, Record_Mod_By = #Session.EmployeeID# WHERE Event_ID = #form.Event_ID# Unable to Create/Update Event: Form Data is Missing