Is the Main Form and Subform linked with a common Field, such as a ClientID Field, in the Subform's 'Link Master Field/Link Child Fields' Property?
It almost sounds as if the Fields in the Subform are not Bound to Fields in the underlying Table.
If, for ClientA, you enter
"ClientA is a Dweeb!"
and for ClientB you enter
"ClientB is cool!"
when you move to ClientC do you see
"ClientA is a Dweeb!"
"ClientB is cool!"
or simply
"ClientB is cool!?"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007