Controlling Table Values...

[Justin]

Hi,

I want to make something like that:

There is a form called A. And there are A & B tables. The row source of form
A is table A.

Briefly, I want to check a field of table B by VBA code. (With IsNull or
something like that...)

I can make it with DCount function. It checks all records. But i want to
check one record. So it is not right code for me.

 

[Klatuu]

You probably need the DLookup function. Look it up in VBA Help to see if it
will work for you. If not, post back with a detailed description of what
you want and we can find the right answer.

 

[Justin]

OK, thanks.

You probably need the DLookup function. Look it up in VBA Help to see if it
will work for you. If not, post back with a detailed description of what
you want and we can find the right answer.