:lol: (my delte record code adds a record)

[SeanK]

Thank you Randem, But before I worship you.... What should i dim RecordsAffected as?

It says variable not defined

What are you using it for? The answer to that will tell you what is should be created as.