I can't get my update to work in my vba code. The relevant part is posted below. I am trying to change the category that a selected SKU falls into. The user chooses the SKU from a list box (Skuchosen variable). Choosing it indicates they want to update the category it belongs to. The update is supposed to change its category id to 10. But when I execute the code, I keep getting a message to enter a "parameter value". Any thoughts?
strsql = "Update SKU " _
& "Set SKUCategoryIDFK = 10 " _
& "Where SKU = " & SKUCHOSEN _
& ";"
DoCmd.SetWarnings False
DoCmd.RunSQL strsql