Looping through a subform records

[315hughes]

Good evening all i am trying to loop through a subform records and i need it to display the selected value from each of the records eg:
record 1 prod# 2
record 2 prod# 5
record 3 prod# 3

so in the above senario it would loop 3 times and each time output 2 then 5 then 3. Currently my code will loop through 3 times but constantly output just the first value(2) attached is the code any help would be much appriceated

Set rs = Me.[sqlOrderDetails subform].Form.RecordsetClone
 
Do While Not rs.EOF
 
prod# = Me.Form![sqlOrderDetails subform]!ProdID
Debug.Print prod#
 
rs.MoveNext
 
Loop
 
Set rs = Nothing

[Rabbit]

That's because you're setting your variable to the value on the form. Not the value in the recordset.

[TheSmileyCoder]

As rabbit has allready explained, line 5 of your code you are reference the values stored in the form, instead of the recordsetCLONE.

prod# = rs!ProdID

should work, assuming ProdID is the name of the FIELD in the underlying recordset.

[315hughes]

Thanks for your help Rabbit and TheSmileyCoder

[TheSmileyCoder]

Your welcome. Glad to be of service.