Invoice report query

[Switchwork]

Hello everyone. Needing more help here.

I run a invoice report from a parameter query using the parameter Invoice No. I used to use the Start date and end date parameter but changed it to Invoice No as I wanted the invoice number to appear at the top of the invoice. By doing the Start dAte parameter I had to change the invoice number manually for each invoice.

Last month i did the invoicing using the invoice no parameter and it was working perfectly this month when i have gone to begin the invoicing. When I use the Invoice number parameter to view the invoice report. The invoice number at the top of the report does not change to the invoice number I entered in the parameter. Why is it doing this?? I really don't want to have to start entering the invoice number manually as it takes not only a long time but to many mistakes are made>

Please could some one help me with this I would be most grateful for any suggestions. It was from this forum that I got the information about changing the parameter to Invoice No to save a lot of time and effort.

Thank you in advnce for all the help.

 

[Rich]

why do you have to manually enter the invoice number?

 

[Switchwork]

why do you have to manually enter the invoice number?

That is what I am trying to find out mate. I thought by changing the parameter to invoice number I would not have to manually enter each invoice number.

At the moment when I enter the parameter for the invoice report when the report comes up the invoice number has not changed. So then I have to go into the design view of the report to change the invoice number manually and it takes a hell of a long time.

What I would like to know is how I can make it so I don't have to do this. I want to be able to enter the invoice number as the parameter and the invoice number be there automatically so I don't have to switch to report design view to change the invoice number for each customer I am invoicing.

I don't know why it does this as the information I was given was that using the invoice number as the parameter should automatically change the invoice number on each report.

I was thinking that it may have something to do with unbound txt boxes or something? Would this be the problem??

Could someone please let me know how I could change this.

Thank you for answering this question much appreciated.

Clare
AKA Switchwork

 

[Rich]

Bind the textbox to the invoice number field

 

[Switchwork]

Bind the textbox to the invoice number field

How do I go about doing that?? I thought it was something to do with bound and unbound txt boxes but don't know how to sort it out. If you could let me know what to do about this I would appreciate it.

Thanx for taking the time to answer my posts most grateful. Will no doubt need more advice in the future about my new design.