I wanted to know how you can update data in a table using the update query
and a parameter query.

How did you want to run this update query?

In query design, you can just put your parameter in the query.
To run it programmatically, you can then use RunSQL in a macro or code.

A better programmatic approach might be to build the SQL statement in code,
concatenating the parameter value into the string. Then Execute the string
itself: you don't need a saved query. The advantage is that you know whether
it worked or not. Here's an example:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jenster84" <u38406@uwe> wrote in message news:79f3d0cc0f520@uwe...
>I wanted to know how you can update data in a table using the update query
> and a parameter query.