Set Change Event on Control from Nested Subform

May 30, 2012
Reaction score
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.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question