Pulling record info from a tabular form in Access 2003

[Himmel]

I may be brain-fried, but I could use some help again.

One of my glorious forms in my multi-form report thingiemajigger is a tabular form. For example, it shows customer items purchased and the price.

"Item1" "1.99"
"Item2" "2.99"

I'd like to pull that data into a single string from another form. But my variable assignment just keeps pulling the first item over and over.

Summary=[Forms]![MainForm]![Orderform].[Form]![ItemName] & " " & _
[Forms]![MainForm]![Orderform].[Form]![ItemPrice]
 
Summary=Summary & ", " & _
[Forms]![MainForm]![Orderform].[Form]![ItemName] & " " & _
[Forms]![MainForm]![Orderform].[Form]![ItemPrice]
 

This results in: "Item1 1.99, Item1 1.99,"

I know I'm missing a loop in here, but what am I looping? I tried an SQL statement that counted the results of the query the data is coming from, but that just made everything function slower and got me nowhere.

Please, save me from my own stupidity! :-)

[Lysander]

I may be brain-fried, but I could use some help again.

One of my glorious forms in my multi-form report thingiemajigger is a tabular form. For example, it shows customer items purchased and the price.

"Item1" "1.99"
"Item2" "2.99"

I'd like to pull that data into a single string from another form. But my variable assignment just keeps pulling the first item over and over.

Summary=[Forms]![MainForm]![Orderform].[Form]![ItemName] & " " & _
[Forms]![MainForm]![Orderform].[Form]![ItemPrice]
 
Summary=Summary & ", " & _
[Forms]![MainForm]![Orderform].[Form]![ItemName] & " " & _
[Forms]![MainForm]![Orderform].[Form]![ItemPrice]
 

This results in: "Item1 1.99, Item1 1.99,"

I know I'm missing a loop in here, but what am I looping? I tried an SQL statement that counted the results of the query the data is coming from, but that just made everything function slower and got me nowhere.

Please, save me from my own stupidity! :-)

I'm not sure if you can refer to the different rows on the form, as they all have the same control name. You can look at the forms recordset and then loop through that, as below, but I don't know how that will affect performance.

Dim rs As Recordset
Set rs = Forms!TEST.Form.RecordsetClone
While Not rs.EOF
'Do what you want to the record set
    MsgBox rs![Cluster ID]
    rs.MoveNext
Wend
rs.close
set rs=nothing