Invoice is now not synchronising

[Bentleybelle]

Thought I had sorted this, but now experiencing another problem. I am creating invoices from my db, invoices may have more than one line. So I have set up a form with client name, invoice number, invoice date on the main part of the form, then the invoice lines as a sub form. The two parts are not synchronising. I want the combo box to find the client for me. I suspect I have something that is really quite simple but fundamentally wrong with this combo box. And I may well have made a mess of it because I have fiddled with it so much. I am attaching the db so someone can take a look.
My invoice form is frmInvoicehdr.
Thanks in anticipation.

 

[RV]

Could you attach a zipfile with a file saved in a lower version of Access (97 0r 2000).
Take into account that not everybody runs on 2002 / 2003

RV

 

[ansentry]

have a look at the attached db (yours changed)

I have created a new invoice form (frmInvoice) and a new subform (sfrmInvoiceDetails), these are for entering new invoices only.

You will have to create forms for searching, viewing etc.

 

[Bentleybelle]

Great - next step

That's great, but what the form format does not allow me to do is view past invoices. I am happy to pull this via a query, but what I need to be able to do is indicate when invoices have been paid, and subsequently chase unpaid invoices. If I calculate invoice total in the query, I cannot simply check the 'Paid' box in the query (which would be sufficient for me). Is there a way around this, or any suggestion as to the best way of doing it?

 

[ansentry]

The form that I did for you is for Invoicing Only. What you now need is a form for viewing Unpaid Invoices and maybe for Paid Invoices. All you have to do is create two queries one with Paid as yes and the other with paid as No.