Dear Gents,
Um trying to loop through my continuous form to print every item in the form with its qty
for example:
first record code 1001 and its qty 5
first record code 1002 and its qty 6
first record code 1003 and its qty 2
first record code 1004 and its qty 3
so i need to print these 4 products with its quantities after each others
i had a try but for sure that was wrong
in the previous code i only tried to show by msgbox the value of the item qty.Code:Dim i As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = Me.RecordsetClone For i = 0 To rs.RecordCount - 1 MsgBox qty rs.MoveNext Next i rs.Close Set rs = Nothing db.Close