I have a stored procedure i SQL which I have created. I
want to be able to execute this procedure in VBA, thus
allowing it to read the values from the form's textboxes
and storing it into the parameter. How do I do so??

This is the codes in my stored procedure:

CREATE PROCEDURE insert_vendor

@VendorID VARCHAR (6),
@CompanyName VARCHAR (80)
AS

INSERT INTO tblVendors (VendorID, CompanyName) VALUES
(@VendorID, @CompanyName)

GO

This are the codes that I've tried out in VBA:

DoCmd.RunSQL "EXECUTE insert_vendor @VendorID =
strVendorID, @CompanyName = strCompanyName"

Thanks!