Parameter query

  • Thread starter Thread starter Vaughn Fisher
  • Start date Start date
V

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
 
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.
 
Back
Top