UPDATE KHB_Lead SET Deleted = 1 WHERE Lead_ID = UPDATE KHB_Lead SET Bride_FName = , Bride_LName = , Fiance_FName = , Fiance_LName = , Phone = , Email = , Wed_Date = #createodbcdate(FORM.Wed_Date)#, Venue = , VenueLocation = , Estimated_Rooms = , Additional_Comments = , Internal_Notes = , Lead_Status_ID = ,Assigned_to_StaffID = ,Assigned_to_StaffID = Null WHERE Lead_ID = select l.*, c.status_sht_name, staff.firstname, staff.lastname from KHB_Lead l inner join KHB_LEAD_Status_Code c on l.lead_status_id = c.lead_status_id left join KHB_Security staff on l.assigned_to_staffid = staff.loginid where l.Lead_ID = select * from KHB_LEAD_Status_Code order by sort_order select * from KHB_Security order by FirstName

#request.thisTitle#

Your update was succcessful!
#dateformat(qryLead.Date_Created,"m/d/yyyy")# #timeformat(qryLead.Date_Created,"h:mm tt")# " >
" >
#qryLead.FirstName# #qryLead.LastName#None Assigned