Thank you, this was exactly the type of code I was looking for. Its so obvious, I'm just not very confident in Access as I am in Excel.
I've tried that line in my code, and I get "subscript out of range" error message. I've define strsql as string, so why am I getting this message?
I've tried that line in my code, and I get "subscript out of range" error message. I've define strsql as string, so why am I getting this message?