Parameter query

[Vaughn Fisher]

What is the process for updating a field in a table that
is part of a query that has a parameter. I want to pass
the parameter to that field. Is there a better way?

Thanks

 

[Allen Browne]

You want to programmatically supply the parameter for an Update query, and
execute it?

Delcare a QueryDef variable in your code.
Assign the value to its .Parameters ("WhateverYouCalledIt")
Execute the query.