Invoicing

[chrisdixon2]

Hello everyone!

Having problems creating an invoice. All i want to do is print one from a form/subform and another payment form. from the payment form. How do i go about it? It needs to print a current sale.

Any Clues?

Thanks

Chris

 

[boblarson]

Depending on how you have your data set up it can be different, but what I've done for a Point of Sale system that I had to create for work was to create a query to pull the main data together and used that as the underlying recordsource for the main report (Invoice) and then used another one for a sub report that pulled the sales line items. The Sale ID was the thing that tied them all together.

 

[chrisdixon2]

Query

Yes ive been trying to base it on a query but without luck. I keep getting an error that the query does not have access to the data. This is annoying as i need it desperately to display the payment method. All the forms do have the sale ID on them. All the forms are also based on querys. Im going to have another look tomorrow (being in the UK its late as typing this message). Thanks for confirming i need a query though. Shall update on progress if any!

Chris

 

[chrisdixon2]

hmm still not having much luck. Any one know of something really simple i can read to help? All suggestions appretiated