Forms and subforms are linked via a date field (dte Log).
When a record is updated or added in sfrm One, I want sfrm Two to requery/recalculate to update calculated values from sfrm One.
Update records in subform from parent form Microsoft Access Development forum to discuss problems and solutions with this popular DBMS. Order ID and Invoice Number fields are in same table? Why have Invoice Number also saved in the child records? If the tables are related by the Order ID then Invoice Number can always be retrieved in query.
FAQ181-2886: How can I maximize my chances of getting an answer? I did read the link, and tried the code, However I could not get it to work. FAQ181-2886: How can I maximize my chances of getting an answer? I guess the common practice for getting data from a subform to the mainform would be as follows;=[subform name].[Form]!
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? I placed a text box on the mainform and used the following; Using the link: Forms! I have no problems on doing it the reverse, ie: getting data from the subform to the main form. Many thanks BTW, if it's the Control Source you may simply use the expression builder (loaded forms). FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
Good afternoon everyone, I am hoping someone can help as I can't seem to find an answer - although I may not be seeing the forest for the trees and if that is the case I apologise.