Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am creating a Purchase Order Form at work using Microsoft Access 2003 so that it can be saved and archived in a database and reduce paper costs.

These are my current dilemmas:

  1. I am unable to figure out how to auto-fill certain fields in the form. For example, I have an PO# Field which will serve as the ID section of the form. I want this to be auto-filled with each new form so that the first form created will have 001 and the second form created will have 002. I haven't been able to figure this out.

  2. I have a section that has Quantity, Unit, Description, Unit Price, Price Total etc. How do I get Price Total automatically filled by doing the following: Quantity * Unit Price

  3. I have Subtotal, S&H, Sales Tax, and Total. How do I get Total to be the sum of all these things?

I have been trying to figure these out using queries and tables, but I can't get it to work. I am currently using Microsoft Access 2003 in Form Design View.

share|improve this question
This require good familiarity with MS-Access. You can't get a quick answer for it. – NoChance Mar 29 '12 at 1:43
Wouldn't this be a better fit for SuperUser or Stackoverflow? This is fairly basic MS Access. – Remou Mar 29 '12 at 7:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.