Hi all,
I've got the following question:
I have a query which calculates the sum of a field per user.
In the form where the query is used there is a button "new". When this button is pressed the query runs. When the result is >= 100 a msgbox has to come up with a message (of course) and else the user may add a new record.
So, how can I use the result of the query as validation in a form (button).
Thnx in advance,
Thijs Kromhout
The Netherlands.
I've got the following question:
I have a query which calculates the sum of a field per user.
In the form where the query is used there is a button "new". When this button is pressed the query runs. When the result is >= 100 a msgbox has to come up with a message (of course) and else the user may add a new record.
So, how can I use the result of the query as validation in a form (button).
Thnx in advance,
Thijs Kromhout
The Netherlands.