dlookup with subforms

[sillysender]

this code works as customer software is the main form
Me![SOFTVER] = DLookup("[VERSION]", "[SOFTWARELINK]", "[DWG#] =" & """" & Forms![CUSTOMER SOFTWARE]![EECPARTNO] & """")

but not with it being a subform

I tried using this, but it doesn't work
Me![SOFT] = DLookup("[TYPE]", "[SOFTWARELINK]", "[DWG#] = " & """" & [Forms]![JOB NUMBER]![CUSTOMER SOFTWARE].[Form]![EECPARTNO] & """")

This coding works with another database but won't work in the one I am currently using
'Me![Description] = DLookup("[Description]", "[Products]", "[Part Number ID] = Forms![Proposed Products Menu]![Proposed Products].Form![Part Number ID]")

 

[PHV]

but it doesn't work
Any error message ?
Have a look here:

http://support.microsoft.com/?kbid=209099

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

 

[MajP]

What does not work? Get an error? Wrong value? Error Message?

Debug it in pieces:

debug. print [Forms]![JOB NUMBER]![CUSTOMER SOFTWARE].[Form]![EECPARTNO]

See if that give you the correct EECPARTNO

debug.print "[DWG#] = " & """" & [Forms]![JOB NUMBER]![CUSTOMER SOFTWARE].[Form]![EECPARTNO] & """"

See if that gives you the correct string. One thing I noticed you return [Version] in the first case and [Type] in the second. I doubt that is correct.