Populate txtbox field in subsubform

[cdgeer]

I have some code from a cmd button on a form that would normally populate a textbox field with a value from a DLookup value. However, I can't get it to work when I place the form on a tab page which is on another main form.

Private Sub cmdFindOldTable_Click()
Dim strSQL As String

strSQL = "SELECT TableName INTO y_tmpGeneral_ProcessortxtTableOld FROM y_LatestExtracts WHERE ((Mid((Forms![Extract Import Tools].Form![General_Processor]![txtTableNew]), 10, 65))=([y_LatestExtracts].[TrimmedTableName]));"

DoCmd.SetWarnings False
DoCmd.RunSQL strSQL

Me![txtTableOld] = DLookup("[TableName]", "[y_tmpGeneral_ProcessortxtTableOld]")

DoCmd.SetWarnings True

End Sub
[Extract Import Tools] is the main form. [EIT_Tab] is the subform on that and [General_Processor] is the sub subform on that.

I replaced the Me![txtTableOld] (which used to work when [General_Processor] was a stand alone form) with Forms![Extract Import Tools].Form![General_Processor]![txtTableNew] but I get an error: "Object doesn't support this property or method."
Any ideas anyone??

 

[PHV]

Forms![Extract Import Tools]!EIT_Tab.Form!General_Processor.Form!txtTableOld

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cdgeer]

Thanks PHV. Tried it but still get "Object doesn't support this property or method." ?

 

[PHV]

You may use the Expression Builder to discover the correct syntax.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cdgeer]

Not sure I follow how the expression builder would help. Isn't that for queries?

 

[dhookom]

There is nothing keeping you from using the expression builder in a query design and then copying and pasting into your code.

Duane
Hook'D on Access
MS Access MVP