validate a number based on a query result

[djcritter]

Hello

I have a field called [Hours]
If a user tries to change the [Hours] I need to check if any of these hours have been assigned to staff in another table.

How do I get to run the query and use the value from the result of the query as the Minimum value?

I would like to
run sql and if the value is being entered into the [HOURS] field is less then show a message and do not change allow the value to change.

I am sure this can be done in VB but I am am unsure of the syntax

I hope U can help

 

[neileg]

I think you need a domain aggregate funtion, probably DMax() because you want a single value to make the comparison, not a query result.