question about null value

[puthenveetil]

Hi all,

i had a form which is based on a query. I used to list a record which is specifically met the criteria..Is there any way to show a message if the query returned no record..My query works well. I only want to add a message if the result is null.

SELECT Institutions.*, Recipients.Rec_ID, Recipients.Spon_ID
FROM Institutions INNER JOIN Recipients ON Institutions.InstID = Recipients.InstID
WHERE (((Institutions.InstID)=[Enter Institution ID]));


Thanks in advance.

Thanks

 

[Mile-O]

Do a count on the query before you open the form to determine if its recordcount is 0 or more.

 

[puthenveetil]

Hi SJ,

If you don't mind, can you show me how to do that...

Thanks in advance


Thanks