update field based on recordsource

[Greg Crowe]

Hello Newsgroup,

How do I update a field in the detail section of a form based on a query
derrived from other portions of said detail section?

In other words, I have a recordset that returns n records. I want to run
the code to set txtSomeField n times based on other criteria present in
n(index) row.

How do I do this? If I fire my code on form_load it only runs for the first
record. After Update and After Insert only seem to affect forms where
people are adding to the data?

I feel like I have missed something exceedingly basic here; anyone care to
help me out?

Many thanks!
- Greg Crowe
- Roseburg, Oregon

 

[Guest]

Have you tried your code in the on current event of the
form?
Bruce