Solved Afterupdate code error to update data from Child form to Parent form

ZKHADI

Member
Local time
Today, 10:44
Joined
Apr 5, 2021
Messages
118
hy buddies!

see below there is an image

Parent Form = StudentRecord
Parent textbox = CurrentFacultySemester

ChildForm = FeeFormSheet
Childform Combobox = Faculty

i applied the afterupdate event on childform / Faculty combobox to add new fee and faculty for a student. when a student reading in current semester which i issued a receipt to him that i need in the Parent form's text box which is existing field in the form's table. i need the current faculty for each student.
i wrote the code but it didnt work i think there is an error.

Update text box on Parentform from Childform

kindly resolve the code.
 

Attachments

  • Untitled.png
    Untitled.png
    292.3 KB · Views: 250
Post code as text, not image. Use the CODE icon on toolbar.

Current faculty for each student should be calculated when needed, not saved to parent table.

If code is behind subform and you want to save data to parent form, why does code try to set value of control in subform? Try:

Me.Parent.CurrentFacultySemester = Me.Faculty.Column(1)
 
Post code as text, not image. Use the CODE icon on toolbar.

Current faculty for each student should be calculated when needed, not saved to parent table.

If code is behind subform and you want to save data to parent form, why does code try to set value of control in subform? Try:

Me.Parent.CurrentFacultySemester = Me.Faculty.Column(1)
thank you it worked.....
 

Users who are viewing this thread

Back
Top Bottom