Hi!
We have a main form with two subforms. The first subform display records related with a plan date for departments and products for a manufacturing area. The second subform is synchronize with the first one in order to display records for the On Current department/product record of the first one.
On the first subform we have a field named Difference(with a total of NumofLots) and a text box label "Coding Misses Unassigned". The idea is to turn off the text box field when the SumofNumLots(hide field) field on the second subform get the same number of the current record on the first subform(this is when all the code misses are assigned).
We write on the After Update option of the second subform the following instructions:
If Me.SumNumLots.Value = Forms![MMS75 Form]![MMS75s37 Subform].Form![Difference] Then
Forms![MMS75 Form]![MMS75s37 Subform].Requery
End If
When the user enter the final total of numlots and this quantity get the same value of the difference field of the first subform the above instructions should requery the first subform and the Coding Misses label should turn off. But this never occurs. We also try this on the AfterInsert option of the second form.
What are we doing wrong? Or anyone has a better idea to turn off the text box field of the first subform.
Thanks for your time.
We have a main form with two subforms. The first subform display records related with a plan date for departments and products for a manufacturing area. The second subform is synchronize with the first one in order to display records for the On Current department/product record of the first one.
On the first subform we have a field named Difference(with a total of NumofLots) and a text box label "Coding Misses Unassigned". The idea is to turn off the text box field when the SumofNumLots(hide field) field on the second subform get the same number of the current record on the first subform(this is when all the code misses are assigned).
We write on the After Update option of the second subform the following instructions:
If Me.SumNumLots.Value = Forms![MMS75 Form]![MMS75s37 Subform].Form![Difference] Then
Forms![MMS75 Form]![MMS75s37 Subform].Requery
End If
When the user enter the final total of numlots and this quantity get the same value of the difference field of the first subform the above instructions should requery the first subform and the Coding Misses label should turn off. But this never occurs. We also try this on the AfterInsert option of the second form.
What are we doing wrong? Or anyone has a better idea to turn off the text box field of the first subform.
Thanks for your time.
