Recent content by Richard_1

Yes Honda, you're right. It's working now. I was too busy to test the loop with messageboxes that I didn't spend time to assign the values to variables. Many thanks to you and Rabbie!

Thank you for the replies. I've change the code as you sugested. See below. I don't get the error message anymore. But the code stops before the loop, while there are more than record in the recordset, because the first messagebox returns: "4 records". I'm wondering if rst.getstring only returns...

Hi, I can't loop through a recordset with the code used below. The first message box says there are 4 records in the recordset. The second message box shows all 4 records in rows at once instead of one by one. I mean it don't show me the values in 4 messageboxes. Then I get the error message...