VBA Access

[Pdugger]

I have a database that I need to monitor for specific items from another database. Example... if a I enter a social security number from tblTest and the same social security number is in tblIneligibility, then I need a window to pop up and tell me that this person was found in the Ineligible table. I need it to allow me to enter the record, but I just need to KNOW that it shows up. Help Please?

Thanks!

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886