By Richard Rost 4 years ago
Continuous Forms. 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!
I'll 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Continuous Forms
Get notifications when this page is updated