Hi Everyone,
First off, I want to thank everyone who has responded to inquiries that individuals like me can learn from.
I have a main form with 2 nested subforms (many to ones) that are linked by their primary and secondary ID's.
Mainform - Hazards (generic information)
Subform 1 - Inspections (info pertaining to inspection of hazard - date,inspector, etc.)
Subform 2 - Photos table (photos for each inspection)
I have a text box that updates from a field on the Subform 2 whenever a user clicks on a new record, Unfortunately, it does not fire an "AfterUpdate" event that I require to run a sub procedure to change an imageframe.
I have tried updating the main form using the ID_lostfocuse event on the subform with -
Me.Parent.Form!txtImageName.Requery without sucess.
I'm hoping you can help.
Thanks
I
First off, I want to thank everyone who has responded to inquiries that individuals like me can learn from.
I have a main form with 2 nested subforms (many to ones) that are linked by their primary and secondary ID's.
Mainform - Hazards (generic information)
Subform 1 - Inspections (info pertaining to inspection of hazard - date,inspector, etc.)
Subform 2 - Photos table (photos for each inspection)
I have a text box that updates from a field on the Subform 2 whenever a user clicks on a new record, Unfortunately, it does not fire an "AfterUpdate" event that I require to run a sub procedure to change an imageframe.
I have tried updating the main form using the ID_lostfocuse event on the subform with -
Me.Parent.Form!txtImageName.Requery without sucess.
I'm hoping you can help.
Thanks
I