Hi again, I promise this is my last post for today!
I've been grinding away at my project hence the volume of posts
As the title above says, I'm using a SQL UPDATE Statement to update prices for an item in a table. However, I've tried tinkering and to no avail, when I click the activation button that starts the sub, it asks for Parameter Value with a pop up. I want to not use this and instead use a text box that user will input.
This is what I've tried and it still doesn't work so any input would be greatly appreciated.
Thanks, Ryan
I've been grinding away at my project hence the volume of posts
As the title above says, I'm using a SQL UPDATE Statement to update prices for an item in a table. However, I've tried tinkering and to no avail, when I click the activation button that starts the sub, it asks for Parameter Value with a pop up. I want to not use this and instead use a text box that user will input.
This is what I've tried and it still doesn't work so any input would be greatly appreciated.
Code:
Private Sub btnComplete_Click()
FlyingFee = txtFlyingFee
LandingFee = txtLandingFee
InstFee = txtInstFee
SQLPayment = "UPDATE tblPaymentPricing SET Price = FlyingFee WHERE ProductID = 1"
SQLLanding = "UPDATE tblPaymentPricing SET Price = LandingFee WHERE ProductID = 2"
SQLInst = "UPDATE tblPaymentPricing SET Price = InstFee WHERE ProductID = 3"
DoCmd.RunSQL (SQLPayment)
DoCmd.RunSQL (SQLLanding)
DoCmd.RunSQL (SQLInst)
Me.lblComplete.Visible = True
Thanks, Ryan