Invoice help

[gebmiller1984]

Hi, setting up a database for the Wifes music business. Have done everything to how we want it all. The Invoices are my problem.
I have a Customers Database with Invoice details etc on the bottom of this form.
what we really want is a separate form to create Invoice details where we can bring customers details into this form to create the Invoice and be able to print but the Invoice details saved for us once its paid to mark it at a later date. Also for the Invoice Details of previous invoice dates to be shown on each Customers Record.

Hope this makes sense. Any help would be appreciated.

Also I have a switchboard but when selecting a form from this board I Can only enter I cannot edit previous records.

Thanks
Grant
DB Novice

[June7]

If you want invoice details then need another table that is related to Invoices table. Then maybe a form/subform/subsubform arrangement.

Really should print report object, not form.

The form possibly has DataEntry property set to Yes. This will prevent display of existing records and only allow entry of new records. Or the code that opens form sets it for new records only.

[gebmiller1984]

Thanks, Have done this and it works but when I click to Print an Invoice it comes up with Parameter Value for Invoice Details, Invoice Date and Total Invoice. Should I be changing a query or something in this.

Help appreciated

[June7]

You have a report? I would have to review the report settings and the code, if any, that opens report.

If you want to provide db, follow instructions at bottom of my post.