errors

  • Thread starter Thread starter pat
  • Start date Start date
P

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....
 
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")
 
Back
Top