issue with the referring subform control in sub form criteria

[siamandm]

Hello All

why this referring control in the sub form not work as below

Code: Select all

[forms]![MainForm]![subForm01]![subForm02].[form]![cbonameID]

i have tried this as well

Code: Select all

[Forms]![MainForm].[Form]![subFrom01].[Form]![subform02].[Form]![cboTestNameID]

any suggestions please?
Regards

[HansV]

Try

[Forms]![MainForm]![subForm01]![subForm02]![cbonameID]

[siamandm]

still same issue :(

[HansV]

Make sure that you use the names of the subforms as controls on their parent form. That is not necessarily the same as their name in the navigation pane.

Could you attach a zipped copy of the database and indicate where to look for the problem?

[Gasman]

If you are trying to refer to a subform within a subform, I would expect .Form for the first subform as control within a form?

http://access.mvps.org/access/forms/frm0031.htm

[siamandm]

here its
the criteria is inside the query stdTestMethod, and the main form name is QualityTestReport

Labtests.zip

[Gasman]

Your first subform control is called tblSamples?

[siamandm]

i renamed it to frmSamples

[Gasman]

Well this produces a value in the immediate window?

Code: Select all

? [Forms]![QualityTestReport].[Form].[tblSamples].[Form].[frmTestResults].[Form].[cboTestNameID]
 1 

However I am getting a prompt for pic attached when trying to open that form?

[siamandm]

yes this is what i get too!

[Gasman]

However I cannot find where you are using it? :-(

[HansV]

The control name of the first subform is tblSamples even though the name in the navigation pane is frmSamples.
So use
[Forms]![QualityTestReport]![tblSamples]![frmTestResults]![cboTestNameID]

Labtests.zip

[siamandm]

thank you very much for the support it works now!

[siamandm]

How i requery the second comobox after updating the first one
i tried this didnt work

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

[HansV]

The version that you attached has

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

That should work.

[Gasman]

Don't go using full form path if your code is in one of the forms.
I closed the form and tried again and I got the query to work

Code: Select all

SELECT StandardTestMethod.MethodID, StandardTestMethod.MethodDescription, StandardTestMethod.TestNameID
FROM StandardTestMethod
WHERE (((StandardTestMethod.TestNameID)=[Forms]![QualityTestReport].[Form].[tblSamples].[Form].[frmTestResults].[Form].[cboTestNameID]));