Are Form 8655 Duplicate 2024

Welcome to another tip video brought to you by Access Learning Zone. In this lesson, I'm going to show you how to copy the last record that was entered into a form so you can make some changes to it without having to retype all the data. Okay, here's the setup. You're entering in product information, but you want to be able to copy the last product that was entered so you can keep all the same information, perhaps aside from one field like the serial number. The product name and sale price that was entered is all going to be the same, but you're going to change the serial number field. I don't want to have to retype all this stuff, and I don't want the user to have to copy and paste it. I want to be able to click on one button and it copies everything from the last record entered aside from this one little field. Now we could write some code that would go to a new record, go to the previous record, select the record, copy it, go back to the new record again, and then paste it, but that's kind of messy. So we're going to use two commands called DMax and DLookup that will look up the latest, the most recently entered product, and then set the new record equal to whatever that product's values were. So here's how we're going to do it. Let's go to design view, let's grab a command button, drop it on our form. I'm going to cancel the wizard and do a little programming here. Right-click, build event, code builder will put us in the VBA editor. There it is, our little command, right there. I'm going to dim an ID as a long integer so I can look up...