DLookUp

[IanT]

Can someone help!
Can't get this to work.............driving me mad.

=DLookUp("[FilterDescription]","tblFilterDescrip","[DescripIDNumber]=" & Forms!frmProductSelector!cboProdDesc)

Thanks in advance!

 

[mlyles]

Not sure but you might want to try this
=DLookUp("[FilterDescription]","tblFilterDescrip","[DescripIDNumber]= & Forms!frmProductSelector!cboProdDesc")
Again I am not sure but it would not hurt to try.

 

[Dembrey]

mlyles suggestion won't work, your orginal syntax is closer.

Personally I prefer the syntax below (although it shouldn't change much). see article http://www.access-programmers.co.uk/forums/showthread.php?t=61539 for lots of discussion on this.

=DLookUp("[FilterDescription]","tblFilterDescrip","[DescripIDNumber]=" & Forms("frmProductSelector").cboProdDesc)

Just a thought, is [DescripIDNumber] defined as a number? If not you'll need to add single quotes. Also check that the bound column of cboProdDesc is a number too.