Getting data on form to print on report

[lfarina]

Hello,

I have a time and billing database that contains a form where the user enters a beginning date and an end date and then must enter an invoice number. All this information will appear in the header of a report. The invoice number will always be different. How can I get the invoice number to print on the report? The beginning and ending date is working just fine, but I can't get the invoice number to print. I think I need to have whatever number is entered to be temporarily stored to a table, but I am not sure at all. I would appreciate any help given.

Thanks.

 

[Rickster57]

invoice number

Place the following code first behind the on click event of the command button that prints the report. This will make certain the info on your form is saved before the print statement is carried out.


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

On your report place a text box where data source= Forms![FrmMyForm].[invoicenumber].

Hope this helps