SetValue to all Records

[KKXC]

I have created a query called DateRequest. DateRequest queries all records
submitted on a specific date. There is also a form created from DateRequest
query. I have created a macro to update the field called SetUpDate with the
current date using the SetValue Function and the GoToRecord to move along the
form.

Since the number of records returned is different every time, is there a way
to tell it to Update All without having to repeat the SetValue, GoToRecord a
hundred times?

Thanks.

 

[Steve Schapel]

KKXC,

Yes. Open the DateRequest query in design view, and make it into an
Update Query (select Update from the Query menu). In the Update To row
of the query design grid, in the SetUpDate column, put...
Date()
Save this update query. You can automate the running of this query from
your form via a macro using an OpenQuery action.