Dlookup issue

[ponneri]

Hi,

I have a Dlookup code on a field in a form. It fires properly and finds if a value already exists in the underlying table or not. And a msg box pops up are as per my code.

But, it behaves erratically. Sometimes, it does not find a value that exists in the field at all.

I need to refresh the form or restart the access mdb for it to work again.

What could be going wrong ? :banghead:

Any help appreciated.

 

[arnelgp]

You need to issue Me. Recalc whenever an independent value that is used on dlookup change for it to get new lookup.

 

[ponneri]

Excellent !

Thank you so much.