There's a few ways you could do it. I'm not sure what video it is but I'll share what I use on one of mine. (note I love using recordsets so I use them, this may not be the "easiest" way.

If MsgBox("You are about to create a duplicate record for the purposes of a warranty replacement, do you want to continue?", vbYesNoCancel) <> vbYes Then Exit Sub
If Me.Dirty = True Then Me.Dirty = False
Dim Db As Database
Dim RS As Recordset
Set Db = CurrentDb
Set RS = Db.OpenRecordset("Select * From WarrantyT")
RS.AddNew
RS!CustomerID = CustomerID
RS!Amount = Amount
RS!OrderBy = [OrderBy]
RS!Note = [Note]
RS!Mileage = Mileage
RS!VIN = VIN
RS!DelNote = DelNote
RS!Invoice = Invoice
RS!DateSold = DateSold
RS!QuoteBy = QuoteBy
RS!SoldBy = SoldBy
RS!InvoiceBy = InvoiceBy
RS.Update
DoCmd.OpenForm "WarrantyF", , , "QuoteID=" & DMax("QuoteID", "WarrantyT")

Copy Same Field

Hi Sami, this is a very good tip, but there is a video where you link to the previous record or other fields on the form to copy the same value linked to buttons, I think something with DLookUp...

copy last record

He Juan, yep, that's him. thank you

Can I attach a note to a button when one clicks over the button that gets my information like in Excel, is that possible....

Can you share a screenshot example of what you mean in excel?

Do you mean show some text when the user hovers over the button?

Control Tip Text

Hi Alex, Kevin, Control Tip Text,  that's exactly what I'm looking for. Thanks,