Hi everyone,
Can someone help me with the following. I have a main form called frmWorkshop. The main form contain 2 subforms called subMaterials and subLabour. All 3 forms have a textbox called Job_number. What i would like to do is the following, when a user inputs information into the field Job_number on the main form i want the other 2 Job_number fields in the subform's to automatically update with the same information.
Also i have a another form called frmCost which contains a subform in datasheet view called subTime.Theres a column in subTime called Labour. I want to be able to sum all the records in that column and display it in a textbox on the mainform. Any help with this would be great.
Thanks,
nim
Can someone help me with the following. I have a main form called frmWorkshop. The main form contain 2 subforms called subMaterials and subLabour. All 3 forms have a textbox called Job_number. What i would like to do is the following, when a user inputs information into the field Job_number on the main form i want the other 2 Job_number fields in the subform's to automatically update with the same information.
Also i have a another form called frmCost which contains a subform in datasheet view called subTime.Theres a column in subTime called Labour. I want to be able to sum all the records in that column and display it in a textbox on the mainform. Any help with this would be great.
Thanks,
nim
