Updating a query

[bailey537]

Hi

I have a form that gets it's records from a query which contains a field with a date. I want to be able to click a button on the form and all the fields in that query get updated so that todays date gets inserted. Can anyone help me?

[jgelpi]

If I understand you correctly you are using a query to filter out...say people with the last name "Smith" and you want to update all of those individual's dates to today's date?

Can you get a little more in depth as to what you are using the query for?