Hi all
I have a Subform within a main form I need a textbox on the main form that calculates a total number of records in the sub form and needs to save to the main table, I have tried a few different methods without any success, I have even tried calculating the record numbers on the SubForm and then showing the number on the main form but cannot get it to show on the table.
I have made a very basic form of the two ways I have tried any suggestions would be great!
I have a Subform within a main form I need a textbox on the main form that calculates a total number of records in the sub form and needs to save to the main table, I have tried a few different methods without any success, I have even tried calculating the record numbers on the SubForm and then showing the number on the main form but cannot get it to show on the table.
I have made a very basic form of the two ways I have tried any suggestions would be great!