Continuous Forms in Microsoft Access. Product Inventory List Form. Click to Open Specific Product.

Learn how to create continuous forms in Microsoft Access. Otherwise known as List Forms, these allow you to scroll up and down and view all of the products in a table or query. We will create a continuous form to display a list of our products. I'll also show you how to click on one of the products, and then click on a command button to open up the single form for that specific product.

Wyatt from Anchorage, Alaska (a Gold Member) asks: How can I display all of my products in a list so that that I can scroll up and down through them. I'd also like to be able to click on one to open up that product's form. A total count of products and my total inventory value would also be nice to see, too. Thanks!

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to calculate a line total (qty on hand * unit price) in addition to form footer totals for the total value of your inventory and the total number of products on hand.

MEMBERS ONLY VIDEO:
   • Continuous Forms in Microsoft Access....  

BECOME A MEMBER:
   / @599cd  

LINKS:
Get on my Mailing List: https://599cd.com/YTML
AutoNumbers:    • AutoNumbers in Microsoft Access: Good...  
What is a Form:    • What is a Form in Microsoft Access?  
Open Form Specific Record:    • Microsoft Access Open Form to Specifi...  
Open Specific Report:    • Display a Single Record in a Microsof...  
On Dbl Click Event: https://599cd.com/aca1

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
FREE Blank Customer Template: https://599cd.com/FRL2
$1 Access Level 2: https://599cd.com/1Dollar
TechHelp: https://599cd.com/TechHelp
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, continuous forms, form header footer, what is a continuous form, columnar form, how to create continuous form, creating continuous forms, open specific record, find specific data to display

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.