msgbox on close of form

M

Maax

hello all, i would like a form to pop up with a msgbox that states "BOM or
Labour is at zero value". The form would simply stay open until the BOM,
Labour or Status is changed.
the msgbox would only appear if STATUS = "engineered" and BOM is "0" or
LABOUR is "0"

I thought the routine would be something like,

If [status] = "engineered" and isnull ([BOM]) or isnull ([LABOUR]) then
msgbox "BOM or LABOUR are at zero value"

Erm i know my terminology is all wrong and i need a bit more but hoped that
this would help indicate my intentions?

any help appreciated.
 
Top