DLookup help 2

[rlmorgan]

Question?
I have a subform that has a input field named “TechName”, and a hidden field labeled “PagerE”. The subform populates the “tblPartsOrdered”. I would like to have the “PagerE” auto update the pager number by what name has been input in the “TechName” field. The data for this is listed in the “tblTechs”. I am trying to use the DLookup function with no success. I have tried variations on the code below.

Any suggestions?

Code in the Control Source of the frmPartsSub.Pager

=DLookUp("[PagerE]","tblTechs","[TechName]")

 

[Remou]

Something like:
=DLookUp("[PagerE]","tblTechs","[TechName]='" & Me.TechName & "'")

 

[rlmorgan]

Thank for the responce. That give an error #Name$ in the Pager field

 

[Remou]

I keep forgetting, no Me on forms:
=DLookUp("[PagerE]","tblTechs","[TechName]='" & [TechName] & "'")

 

[rlmorgan]

Thanks, I've been working on that for over 4 hours.

That solved my problems

 

[Remou]

You are most welcome.