What event fires in a subform when you move record in the main form? It can't be On Current, since there may be no records in the subform for that record in the main form.
What event fires in a subform when you move record in the main form? It can't be On Current, since there may be no records in the subform for that record in the main form.
there may be none, since the master form doesnt affect the subform.
but On Current should fire, but yes, if no records, then no current.
The current event of the main form will fire; I don't think anything will fire in the subform.
Ah, then I may need a different approach. I want AllowAdditions to be True or False for the subform depending on the value in one of the fields of the main form. The problem is that the new record row in the subform appears or disappears (it's a continuous form) before the subform has requeried - if that's the right way to put it - which looks odd. Is there any way of preventing this?
I'd set that property in the current event of the main form, and probably the after update event of the control containing that value.
"I'd set that property in the current event of the main form".
Unfortunately, that's what I'm doing already. The problem is that the new record row is appearing at (or disappearing from) the bottom of the records on the subform before the records relating to the record on the main form that I've moved to are displayed.