Query and text box

[ptrifile]

I have a form that is bound to a table and the record source queries and totals data. I want to have multiple text boxes on my form each showing one of the results from the query. How can I change which row is shown in the text box on the form. Currently I can only get it to show the first row in the query. Hoping someone can help.

Thank you in advance

Paul

 

[PHV]

Use a continuous form ?
Follow the wizard to get a navigation pane ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ptrifile]

Once again thanks PHV! At first glance that did what i needed or so I thought. I have totals for different weeks (you helped me earlier with the query). Now what I would like to do is show the % increase or decrease from the previous week. I thought that if i could get these totals in their own textbox I could simply use an unbound text box to calculate each week, howeveer, with a continuous form its still only 1 text box. Make sense?

Thanks again.

Paul