Update Form Field

[billheath]

I know this should be easy but I am drawing a blank!
I have a form which allows me to enter time and other info per project the employee works on in a day. (One record per project per day) Once the info is entered, VBA populates fields for total hours worked for the current project and total hours the employee worked that day. This part works fine. However, I would like to be able to populate all records for all projects on that particular day. There could be as many as 20 records for one day.

One for instance: Total hours worked for the day. Is there a simple way that when total hours is changed, vba could update the same field in all of the records for that day?

Thanks in advance. Hope I have stated this clearly.

The data base is called "ProjectTime" and the form is simply called "Time Entry

 

[timfoster]

If you're looking to update all the same field in the underlying table, then you could easily run:

currentdb.execute "UPDATE Table Set Col = x "
You'll need to refresh your recordset afterwards