You're going to love this...
Since you are using a tabular form, there is no way to reference an individual cell within the tabular form (i.e. ModuleStatus in your case). If I say ModuleStatus = "Alabama" how does it know which one to change? So, it only changes the selected one.
This is by far and away the most ghetto feature in the world about Access. I had a similar gripe recently, which went unresolved. I wanted to be able to insert a break when the value of a column changed, as I went through; but, there is no way possible to have Access evaluate the records in the detail before it prints them out.
This is all entirely nonsensical, since you know that from an event-standpoint, the database opens a recordset and iterates through the recordset, printing out rows. O.K., my soap box is worn-out now, but the long-and-short of all of this is that you cannot do what you would like to do (maybe you could emulate selecting each of the rows in your form, and react to that event using OnCurrent -- but things shouldn't have to be so hokey!)
Sorry man, right Bill, and tell him how much his product sucks for being in its 500,000th revision.
