MsAccess - Update Parent Form with Sub Form Control References

In Microsoft Access there is a dirty little trick you can use in reference in a expression in the Controlsource property to update the parent form when a record in a sub form was edited by the user.

[@bumpersmith]

Thanks for the new video. Nice to see you back. It's been awhile.

[@pythonstatistical4105]

Thanks for this exactly what I need!

[@darray7472]

Good to see you again!
I love Access, but I use it much less than I used to.
Power BI is what most analysts want to use here in the US.

[@diegobarcelos5272]

You save me again Mr., great video! Thanks a lot, regards!

[@RungeCarl]

Always enjoy your videos. Great production but please ue more ZOOM so we can see your syntax

[@codekabinettcomen]

Thank you very much! I took note of that.

[@ourfamilygarden]

Interesting concept, thanks! Regarding the date example I think you could simply have the IIF function return the desired date value which would alleviate the data type conversion issue. Something like IIF(txtRecordID, Now(), Now())

[@codekabinettcomen]

Thanks for the comment.
I could have used your suggestion and for the simple Now() expression it doesn't make a difference except fixing the data type issue. However, for more complex, nested function calls or calls with multiple arguments, I think it is easier, more readable, and maintainable to append the IIF null string expression and do the type conversion. So, I choose that to present an approach that can be applied to expressions of any complexity.

[@abdulhamidalhaddadi2255]

Thank you sir

[@ledahbernardi1070]

Hi, great explanation, tks. Do you have any video, teaching how to display a button on the last register of the subform? I need a [Save] button, visible, only on the last register, on the subform. Thanks, again, for the great explanation.

[@codekabinettcomen]

There is no video about that.
But you can check for the last page of a tab control with code similar to this:
Me.YourButton.Visible = (Me.YourTabControl.Value = Me.YourTabControl.Pages.Count - 1)
The YourTabControl_Change event would be a good location to check for this.

[@ledahbernardi1070]

@@codekabinettcomen thanks a lot, I´ll try that.

[@SAMYTAHER]

thank you
We need
I need code that will compare two different databases (ACCDB split database)
The purpose is to update the old customer database with new updates without deleting the old database data
The tasks of the codes are:
* If a table exists in the new database and does not exist in the old database, a copy will be made
* It compares the fields for you table in the event that a field is found that does not exist in the old database, it creates the right
* It compares the properties of the fields for each field and the properties of the fields in the old database are modified
* Modifies the relationships between tables to be like the relationships in the new database