Help with DlookUp

[hmho]

I have form that is based on table I also have field to look up product name from another table =DlookUp("ProdName","TblProducts","ProdName= & nz([ProdNum],0)). What is happening sometimes with same product I'm geeting the name and sometimes it is coming back blank

 

[pbaldy]

See if this helps:

http://www.mvps.org/access/general/gen0018.htm