VS 2005 and sending mail via smtp
I have setup a form that contains a database (design view) and the database works. I can insert/delete/update. Off to the side I have 13 checkboxes containing peoples names. When checked it writes text to an invisible textbox (not part of the db) the email address. This is so I can select who I want to email if it's 1 or 13. Everything works great. The e-mails the data it is perfect. The problem is that the "send mail" button only works when I am on the first record of the database. If I go to record two it will not send an e-mail. The toughest part is their are no errors.
fyi. the issue id Auto number and the issue itself is contained in the e-mail as subject title and body. Let me know if there is anymore info I am leaving out to understand the issue. I will be more than happy to post any code. Thank you.
I actually figured it out. I added auto increment at the end for issueid and I deleted all test records to start with a zero number and it now works. Not sure why that even affected the mail option but it did. Still, comments are welcome.