When printing report it prints all records not the 1 i'm on 1

[markswan20]

Hi everyone.

I have created a form that prints all relevant boxes into an invoice.

I have assigned a command button to my form to print report but instead of printing that specific record it prints them all is there some code i could add to the onclick that stops this thus helping my problem?

Kind Regards
Mark

 

[ZmrAbdulla]

Print Only Current Record

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Hi ZmrAbdulla,

Thank you for your reply it's working fine and well now.

I have only 1 other question.

On my original form i have code in a bound text box adding up the totals displayed in 11 product price boxes. Now when i scroll through the records it takes a split second for this total to appear. On my report i have a totals box which when viewed in print preview or when printed show this total from my form.

I originally added the box using the wizard but it never displayed anything from the outset. I have tried binding the totals box manually and also creating a second box on my form that took the total from the original and bound it to that but it still wont display anything.

I sometimes get the error ENTER PARAMETER VALUE.

No matter what i do it wont display the total.

Can you help as this is driving me mad.

Kind Regards
Mark

 

[ZmrAbdulla]

I can't understand why textbox is bound!!( I assume the it is a continues form) just place a textbox on the footer of the form then set ControlSource =Sum[FieldName] this will bring the total in the text.

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Thanks for your reply ZmrAbdulla

I have just tried your solution and it's telling me

The expression you have entered contains invalid syntax
You may have entered an operand without an operator.

The code i have used is =Sum[text106]

I'm sorry to be a pain.

Kind Regards
Mark

 

[ZmrAbdulla]

I am sorry.. it shoud be
=Sum([text106])


________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Thank Zameer.

It's gone past the error now but it's still not filling the field with the total it's just blank.

Many Thanks
Mark

 

[markswan20]

Thanks Zameer.

I have rewritten the code within the report to take the total from there as opposed to the form.

Thank you very much for you help.

Mark

 

[randy700]

Unless text106 is the name of the field in your table, =Sum([text106]) won't work. My guess is that your text box name is text106 and the field is something else. So, try using =Sum([TheActualFieldName])


Randy