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:

BECOME A MEMBER:

LINKS:

ADDITIONAL RESOURCES:

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.

[happiedaizie]

I love you dude. This was fun. Thank you kindly.

[akokohjoel]

Thanks for your fine work, you are effective in teaching ms access.

[hardysingh]

Thanks richard sir, your videos are helping me alot, thanks.🙏

[zaagj]

thanks for the video.... really solved my problem

[shamim]

im searching this video long time
thnxx sir

[alicito]

Hi Richard, thanks a lot for this very intuitive video about Access... I´m a Mac user and I had no idea haw can I use Access... Noy thank you I can create Inventory for my Slide Collection easily 😃

[rluxon]

I have a database for creating labels for inventory products (1 label per product number that is concatenated (thank you for that Richard). I have a form with all inventory that I filter for my records. They have a checkbox to select for printing. Is there a way to create a button to select all? Something easier than selecting the checkbox 726 times?

[JackWMatrix]

Gee, I work with a programmer named Wyatt who moved to Alaska.

It's probably the other Wyatt in Alaska.

[adolfyuda]

do you have a video on add a new patient/customer with at least one treatment/product please. l am one of your silver members by the way

[thejose]

Hey Rich! Is there a way to highlight the entire row and not just one field when selecting an entry on the continious form?

[rabidfollower]

I would use a form datasheet in a subform for this. I've used datasheets a lot in my 20+ years mainly because of the easier and more intuitive navigation. They look like an Excel worksheets and the arrow keys navigate as you expect. On a continuous form, however, pressing down goes right instead, and up goes left. Datasheets also allow column width adjustments and alternating row colors for readability, neither of which can be done on continuous forms. But datasheets also have many shortcomings. I've seen tons of people on the Internet who prefer continuous forms. I don't see any videos on datasheets in your channel, so I'm guessing you are not a fan either.

[aqeelabbasjanayyaalioffici]

Hello, please also tell how to build database for library management system in which you can add student, staff and issue and return books form, auto over due fine and also generation of their reports.

[artistryartistry]

FYI You can change the alternate color feature by right clicking the form and choosing from the context menu. A little bit faster than going into the properties :)

[jeanmcgowan]

Can you create a continuous from from a query? I have a bunch of calculations and it looks like excel so it is easier for my users

[mikehoy]

Thanks for the great tutorial. Unfortunately my wizard does not work. Any ideas to get it working or program the button without the wizard.

[SAJONY-gkfd]

hi Richard make a video on how to load another continue form with related record by click button. for example: customer to order/contact or order to order details as your member only video. Please.

[nathanseber]

Hello. After creating the form, I needed to change the primary key from employee ID to an auto number. I now need the form to pull from the auto number in the filter instead. How can I change this? The reason being when I click to open an employee it is pulling the old information and not the updated one. We want to keep the original one for audit purposes.

[grahamhendricks]

Hi Richard, can you help me the following. According to your tutorials On ship date products moving out of stock with click on command button and on return date stock return back into stock with a click of command button. Want to use one button click to activate the the above process. Is this possible? Regards Graham

[marklefler]

Richard, do you have a video that shows how to make a query result show in a subform and not make a new page/tab with the results?

[FLORIDAPERSONable]

How would you do a continuous form if you have two table with a 1 to N relationship. So in this example, products and who bought them?