Summary Textbox Loop Issue

[access101]

I'm finally finished building my delivery system. I have a query which works fine the issue is every time i click on a item on my form the screen flickers. The form is a continuous form and on my form i have a list of menu items when i click on them it updates my summary textbox. but in order to show up on my textbox i need to run a docmd.openquery then refresh the form which is causing my flickering. below is the query that i run and was wondering if i could not use a query but use a vba string instead. i tried writing out the vba code me.summary = me.summary & me.sandwich & etc. but it reproduces all the previous entries.

Expr1: IIf([Bread] Like "*",[Bread] & " " & [Sandwich] & " " & [Expr2] & Chr(13)+Chr(10),[Sandwich] & " " & [Expr2] & Chr(13)+Chr(10)) & IIf([Extras]<"S*",[Extras]) & IIf([Veg]<"S*",[Veg]) & IIf([Packets] Like "*",[Packets]) & IIf([Chips] Like "*",[Chips]) & IIf([Cookies] Like "*",[Cookies]) & IIf([Othersides] Like "*",[Othersides]) & IIf([Drinks] Like "*",[Drinks]) & Chr(13)+Chr(10)

 

[access101]

runtime error 3265

Item not found in this collection

 

[lameid]

Having been away from this for a few days... It seems to me all you want is a basic report to display the order details.

All you need to do is display the data differently. Just stack the controls on the report in the detail section how you want to view them for each record. Access can then display the records.

Just remember to filter by your order or whatever it is that ties everything together.

And if you do not have such a thing, you definitely will need to post your table layout with all Fields, please note any keys.