Move First if you want to move through the recordset).
In this blog post we will be demonstrating how to loop through a recordset.
Net web development, PHP, Excel & Outlook customization. Ideally I would have indented the nested transactions but I don't have enough room on the screen to make it readable.
Open Recordset("SELECT * FROM ORDER_DATA WHERE SKUS_ORDERED = '" & cur SKU1 & "' AND [ORDER] = " & cur Order) Set temp_rst2 = db. ADO is the default object library for Access, but DAO is still available.If you use a DAO Recordset, you must explicitly reference it.Referencing both libraries is likely to generate an ambiguous object error.To avoid this type of error, give priority to the library that your code references the most.