We'll begin by adding reorder levels and vendor information to our product table, so we know when we should order more of a product, and from whom to order it.

We'll add this information to our Product List form, so we can quickly see at a glance what products need to be ordered. A little Conditional Formatting makes those items stand out.

We'll create a Purchase Order table to track items that are On Order. Next we'll make an "Order More" button on our product list form.

The system will prompt us for how many items to order.

The items then get added to the Purchase Order table. We'll build a form where we can review all of the items that are to be ordered, filtered by vendor.

We'll finish up the purchase order, including a printable report, in the next class, Access 329.

Access 328 - Course Outline

1. Reorder Levels
Add Fields to Product Table
Reorder Level
Vendor Information
Quantity On Order
Vendor Table
Add To Product Form
Query to show Products Understocked

2. Purchase Orders
Products Understocked Form
Purchase Order Table
Purchase Order Details Table

3. Order More Button
Create Order More Products Sub
InputBox to Ask How Many
Convert string to number: CLng function

4. Make Purchase Order, Part 1
Create the Make Purchase Order Code
Creating a PO with a Recordset
Get the assigned Autonumber for a record
Check if there is a PO for this vendor

5. Make Purchase Order, Part 2
Check if this item is already on a PO
Use recordsets to create the PO and details
Verify table data

6. Purchase Order Form, Part 1
Create Purchase Order Details Subform
Create an unbound ListBox to show all POs
OnClick event to show only items on selected PO
Bind the form to Purchase Order Table
Show Notes

7. Purchase Order Form, Part 2
Check Box to Filter Open/Closed POs
Check Box to Filter Received/Not POs
Tri-State CheckBoxes (Triple State)
QuickLinks to Set the Checkbox Values