why this referring control in the sub form not work as below
Code: Select all
[forms]![MainForm]![subForm01]![subForm02].[form]![cbonameID]
Code: Select all
[Forms]![MainForm].[Form]![subFrom01].[Form]![subform02].[Form]![cboTestNameID]
Regards
Code: Select all
[forms]![MainForm]![subForm01]![subForm02].[form]![cbonameID]
Code: Select all
[Forms]![MainForm].[Form]![subFrom01].[Form]![subform02].[Form]![cboTestNameID]
Code: Select all
? [Forms]![QualityTestReport].[Form].[tblSamples].[Form].[frmTestResults].[Form].[cboTestNameID]
1
Code: Select all
Private Sub cboTestNameID_AfterUpdate()
[Forms]![QualityTestReport]![tblSamples]![frmTestResults]![cboTestNameID].Requery
Me.txtMethod.Requery
End Sub
Private Sub Form_Current()
[Forms]![QualityTestReport]![tblSamples]![frmTestResults]![cboTestNameID].Requery
Me.txtMethod.Requery
End Sub
Code: Select all
Private Sub cboTestNameID_AfterUpdate()
Me.cboMethod.Requery
Me.txtMethod.Requery
End Sub
Private Sub Form_Current()
Me.cboMethod.Requery
Me.txtMethod.Requery
End Sub
Code: Select all
SELECT StandardTestMethod.MethodID, StandardTestMethod.MethodDescription, StandardTestMethod.TestNameID
FROM StandardTestMethod
WHERE (((StandardTestMethod.TestNameID)=[Forms]![QualityTestReport].[Form].[tblSamples].[Form].[frmTestResults].[Form].[cboTestNameID]));