Purchase Order Numbers Auto Populate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of purchase order information and I would like the puchase
order # to automatically populate. The first two numbers are the Fiscal Year
and the last 4 are the purchase order number (060001, 060002 and so on). How
can I get that field to automatically populate when I am entering new
purchase orders in my form?

Doc ID Agency Doc # Vendor Purchase Desc Amount
DO 242 060001 McMaster-Carr Gaskets $150.00

Any help is greatly appreicated.
 
Sonya

What you might be looking for could be called a "custom autonumber" (this is
a misnomer, but it stuck). Try mvps.org/access to look for an example.

By the way, if this is something like an Order system, you may want to take
a look at the Northwind database that accompanies Access as a sample. And
your "order detail" record seems to be missing a "Quantity"...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top