Hey,
I hope one of you wizards out there can help.
I have a main form and subform with a one to many relationship.
Some main records contain no subform records and others can contain 20+.
My goal is when the main form changes record i want the subform to always go to a new record regardless of how many records are in that subform record set.
I can use the main form's PK change as the event to trigger it off, im just unsure how to do it.
And Vice versa when an event happens (like a change to a field value) on the sub form i want to be able to change the value of a field on the main form to reflect this change on the lost focus event of the sub form field, is that possible?
If anyone can give some examples i would be a happy chappy.
Thanks.
I hope one of you wizards out there can help.
I have a main form and subform with a one to many relationship.
Some main records contain no subform records and others can contain 20+.
My goal is when the main form changes record i want the subform to always go to a new record regardless of how many records are in that subform record set.
I can use the main form's PK change as the event to trigger it off, im just unsure how to do it.
And Vice versa when an event happens (like a change to a field value) on the sub form i want to be able to change the value of a field on the main form to reflect this change on the lost focus event of the sub form field, is that possible?
If anyone can give some examples i would be a happy chappy.
Thanks.
Last edited: