Microsoft Access Unbound Field

[dctechuser]

Hi everyone,

I have a Parameter Query that I am running to pull records from an Access database. The user is entering the last four of the Social Security Number to retrieve records with a Message Dialog Box. I need Access to give a message, "No Records Found" in an unbound field on the form when the Parameter Query runs and finds no records.

I have a Form with SSNNumber (Four Digits Entered Field)
SSN (Full Social Security Number field)
Last name
First name
Middle Initial These fields display when records are found.

How can I do an IF function inside the unbound field which I call Status to show "No Records Found" when there are no records found.

 

[SkipVought]

Hi,

Please post MS Access questions in one of the many MS Access forums, like forum705 or forum702.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]