I have a form which takes in a userID through a textbox, the user then clicks a button which forwards them to a report. I'd like to pass on that userID variable so that I could call it in my query:
execute dbo.someStoredProcedure
@UserID = [Forms]![FormName]![userID]
However I keep getting a syntax error and I'm not sure the variable is being passed on...