errors

[pat]

How do i display a msgbox that is warning only where a
value in a field meets a certain condition.

the way of determing the existance of the condition is by
looking at the value and comparing it with a table of
values via a query, so in effect i want to say if the
query returns the value 'fail' then a message is
displayed. i run the queery on 'on change' and 'before
update'


thanks....

 

[G. Vaught]

You should be able to do this with code.
On a form write some code against the after update event.
Do a DLookup to look up the value in the query or table that equates to the
value in the form.
If it meets the criteria then
MsgBox("This value has failed")