Recent content by jemartin80

In any case, thank you for your help. I've learned something I can apply now. It may not do just what I wanted but its a start.

Oh, well I can't have that. The rest of the record needs to be open to editing. So there is no way you know of to update that field with a different value for each record?

Jal, if you look closely, the value is not assigned to the unbound textbox until after the do loop is complete, so the values are not being overwritten before they can be seen. But thank you for your suggestion. namliam, thank you for working with me on this. I am not very familiar with query...

I will try to be more clear. When I open my datasheet form the code currently sets the value of the unbound CompTime field to the same value for every record. I would like it to set a different value in the CompTime field for each record. The following is the code I am using for the Current...

I'm sorry, that was very unclear. It is still setting the value for the CompTime field the same for every record on the datasheet form.

I just gave that a try and it is still setting the value for all the fields to the same value. When I debug, it is only running through the code one time, instead of once for each record.

The issue I am having seems like it should be simple, but they often do and seldom are. When I load a datasheet form I want to update one field (CompTime) for each record with a different value (sTotalTime). I am using the Load event for the form to run a code that is meant to generate the...