I have a subform with multiple records tied to a main record and main
form. In the subform I create and update the subform records. However,
there are other pieces of data, statistics, I want to add automatically
to the record when it is saved. I can access the data via VBA code in a
"before update" event. Any way to address the record itself and all
fields - even fields not on the form?
So far I figure I could
1) put all the statistics fields on the subform layout, hidden and
protected, all bunched on top of each other (15 fields). Might make
debugging difficult.
2) Instead use the after update event. Get the record key, an
autonumbered field, after the update and use VBA code to read the
dynaset and update the record.
Other suggestions?
Bob Alston