Textbox loop through recordset

[access101]

I have a form which also has a subform on it. On my main form I have an unbound textbox which has this as its controlsource ="Expr1: [Sandwich] & IIf([Notes]=Null Or [Extras]=Null Or [Sides]=Null Or [Drinks]=Null,Null,Chr(13)+Chr(10) & [Notes] & [Extras] & [Sides] & [Drinks]) & Chr(13)+Chr(10) & Chr(13)+Chr(10)".

The issue im having is that it is only showing one row. I need it to loop through and display them in my textbox.

I want my textbox to look like this:

Sandwich
Notes
Extras
Sides
Drinks

Sandwich
Notes
Extras
Sides
Drinks

Etc....

 

[dhookom]

faq701-4233

Duane
Hook'D on Access
MS Access MVP