Update fields from subform to main form

[gstylianou]

I greet all forum




I need once again the help of more experienced ....


On my database I have a form (frmCustomers) that incorporates a subform (subfrmCustomerDetails). In the subformCustomerDetails i have the fields "Age" and "Height". I need when updating those fields the corresponding fields "Cage" and "Cheight" which are located in the main form (frmCustomers) to be updating also.


Although I have tried various methods i have not managed to achieve the desired solution. So, i have error from vba.


Any help welcomed and appreciated.


Sincerely,

[ItsMe]

Here is some reference material to get the syntax for referencing subforms
http://access.mvps.org/access/forms/frm0031.htm

Having said that, make sure not to duplicate data from one table to another unless said data is a Key value. Storing literal text from multiple columns of a single record is not normalized. Store the Primary Key value from one table in the corresponding Foreign Key field of another table. Then, join on the PK/FK fields in your queries to retrieve relative data of your relations.

[ranman256]

I see no reason for a child record to update a master record.

[gstylianou]

Ramman the field "Age" is a calculated field, that's why i need this update.

Its me, i will check out on the article and i will let you know. Thanks

[gstylianou]

Good morning all,

i would like to thank you very much for your help. This issue has been solved because of your help.

Thanks a lot

Regards