Need Parameter in Update Query

[Guest]

Hello Everyone! Using A02 on XP. I have a report to print bills for
statements mailed for calendar quarters between [StartDate] and [EndDate] and
a query creating fee records for each. I'd like to be able to allow the
person running the macro to be able to state what the [CostPer] should be and
have a query update that field for those records that fit the date criteria
(same records in the report and create fee record queries). Right now the
query has to be opened in design view and the [CostPer] amount changed and
the query is then run. It would be really, really nice to have a parameter
ask [What CostPer?] and have the current cost defaulted in the parameter so
you only type something if it is a different cost. I hope I have described
my situation well enough and thank anyone for their time and help.

 

[fredg]

Hello Everyone! Using A02 on XP. I have a report to print bills for
statements mailed for calendar quarters between [StartDate] and [EndDate] and
a query creating fee records for each. I'd like to be able to allow the
person running the macro to be able to state what the [CostPer] should be and
have a query update that field for those records that fit the date criteria
(same records in the report and create fee record queries). Right now the
query has to be opened in design view and the [CostPer] amount changed and
the query is then run. It would be really, really nice to have a parameter
ask [What CostPer?] and have the current cost defaulted in the parameter so
you only type something if it is a different cost. I hope I have described
my situation well enough and thank anyone for their time and help.

You would use the same method as you already have with the date
prompts.
If you are writing the query using the query grid, on the [CostPer]
Update to: line write:

[What CostPer?]

When you run the query, you will be prompted to enter the new value.