The pollution of water bodies by heavy metal ions has recently become a global concern. In this experiment, a novel chelating resin, D851-6-AHHA, was synthesized by grafting 6-amino-N-hydroxyhexanamide (6-AHHA) onto the (-CH2N-(CH2COOH)2) group of the D851 resin, which contained a hydroxamic acid group, amide group, and some carboxyl groups. This resin was developed for the purpose of removing heavy metal ions, such as Cr(III) and Pb(II), from water. The findings from static adsorption experiments demonstrated the remarkable adsorption effectiveness of D851-6-AHHA resin towards Cr(III) and Pb(II). Specifically, the maximum adsorption capacities for Cr(III) and Pb(II) were determined to be 91.50 mg/g and 611.92 mg/g, respectively. Furthermore, the adsorption kinetics of heavy metal ions by D851-6-AHHA resin followed the quasi-second-order kinetic model, while the adsorption isotherms followed the Langmuir model. These findings suggest that the adsorption process was characterized by monolayer chemisorption. The adsorption mechanism of D851-6-AHHA resin was comprehensively investigated through SEM, XRD, FT-IR, and XPS analyses, revealing a high efficiency of D851-6-AHHA resin in adsorbing Cr(III) and Pb(II). Specifically, the (-C(=O)NHOH) group exhibited a notable affinity for Cr(III) and Pb(II), forming stable multi-elemental ring structures with them. Additionally, dynamic adsorption experiments conducted using fixed-bed setups further validated the effectiveness of D851-6-AHHA resin in removing heavy metal ions from aqueous solutions. In conclusion, the experimental findings underscored the efficacy of D851-6-AHHA resin as a highly efficient adsorbent for remediating water bodies contaminated by heavy metal ions.