Update a parameter query?

arage

Registered User.
Local time
Today, 22:27
Joined
Dec 30, 2000
Messages
537
Update a parameter query?
I’m running a parameter query, and based on the results I see I’d like to be able to update the filtered (paramaterized?) recordset using an update query (I guess) Is this possible? I guess I’m afraid of updating anything other than the results brought up by the parameter query.
 
Do you want to view the results of the parameter query before deciding whether to update the recordset, or do you want to automatically run the update?

If you want to automatically run the update, you can specify criteria to select the records to update just as you specify records to display in select queries. when you run the query, only the records that meet the selection criteria will be updated. If you're worried about changing the wrong data, make a copy of your database and practice with it until you feel comfortable.
 
Well, I guess that’s my answer, yeah I wanted to be able to update the query without viewing the selected records before hand. I tried testing it like you said and it seems it’s the way to go for me currently. Thanks!
 

Users who are viewing this thread

Back
Top Bottom