How do I pass information between Forms into Variables?
I'm looking to understand the best way to pass user information from a form into a variable on another page so that it will be used to affect the output of my Recordset and dynamic form.
I've created an SQL statement in my recordset for my dynamic form that uses a variable (VarWeek) to determine the data that is displayed in the form. I want to be able to take a value from user input and put it in this variable.
What is the best way to do this? I have been reading and I guess a Form Variable is one way? I can not figure a way out
My Recordset SQL statement.
SELECT t.TeamName, t.managername, Sum(s.points) AS TotalPoints
FROM nh_scores AS s, nh_team as t
WHERE t.teamid=s.teamid AND s.weekid between 1 AND VarWeek
GROUP BY t.TeamName
ORDER BY Totalpoints DESC
I have created another page that contains a form which asks for a week number. I would like to take this number when the user clicks submit. Put the number into the VarWeek variable in my recordset so the output is appropriate.
Can someone please provide me with some direction and if possible a tutorial.
Thanks!
Nath
Comments
Be the first to write a comment
You must me logged in to write a comment.