Welcome to another free tutorial brought to you by Access Learning Zone. My name is Richard Ross. In today's video, I'm going to show you how to use a command button to open a form to a specific record. We'll have one form, which is a customer list. We'll click on a customer record, then click on a button, and that will open up that specific customer record in my database. I have a customer table that has all my customers in it. You can see my first name, last name, company name, address, city, and the customer ID. Now, I have two forms for customers. I have a customer form, which is a simple customer form with all the customer information on each page. It's a single form, one customer per record. I also have a customer list form, which is a continuous form, also known as a multi-item form. I can scroll up and down through the different customers. What I want is to be able to pick one of these customers and then click a button to open up the full customer form for that customer. How do I do that? Well, there's a command button that allows you to do this. Let's go to design view on my customer list form. On the ribbon form design tools, there's the command button tool. Click on that, then come down here and click in your form footer. The wizard opens up. I'm going to select "Form Operations" > "Open a Form". Next, which form do I want to open? Well, currently I'm on the customer list form, so I want to open up the customer form. Next, do I want to show all the records or find specific data? I want to find specific data to display. Now,...
Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 2350 Toggle
