Access project

[CKS]

I have little experience with access. I am trying to create an invoicing system that will allow me to select items from a list and enter a quantity. Then use a macro to sum the totals. The problem I am having currently is creating the sub-form that has the combo boxes that will allow me to select the items. I have no VBA experience and am trying to avoid it. There is a template that I have been using to try guide me but it gives no explanation and I can't really follow.
Any help would be greatly appreciated.
The link to what I have so far is as follows: https://dl.dropboxusercontent.com/u/...0Project.accdb

CKS

[June7]

That project doesn't use VBA but it is loaded with embedded macros. I don't use macros, however, I can usually understand them well enough.

Why would you need a macro to sum records? That's what aggregate queries and reports are for.

Where did you get the template from? There appears to be a circular relationship between Customers, Invoices, and Jobs tables. This can be problematic. Should not have customer in both Jobs and Invoices. The JobID in Invoices will get you to the customer.

This is a simple db. If you acquired a basic understanding of relational database principles before trying to develop a db, your experience will be less frustrating.

Exactly what is the issue you are having?