Only if there are no records from this query, can you fill in this box

[ADRIANCULLEN]

My database has 2 tables, one for people and another for events for those people.

I need to check that a certain field on all the records in the second table for an individual has been completed before allowing a field in the other table to be updated.

I can write the query to do the checking based on an IDno used as the link between them and "is null" for the criteria for the required field but how do I store the information that there are no records in such a way as to use it to test entries in another control and produce a message box?

 

[Remou]

It might be easiest to use Dlookup. The alternative is a recordset.

 

[ADRIANCULLEN]

Thanks Remou

I probably didn't make myself clear but I don't need to know the values, just the number of records which are null.
DCount does this for me.

Thanks for the help.