Simple IF?

S

SusanV

How can I set a MsgBox if a form's field isn't filled in when a button is
clicked? (The form works off a temp table and this button populates a
permanent table and this field is required in the permanent table)

TIA,
Sue
 
R

Rick B

Aircode...


sub... on click...
If IsNul([SomeField] then
Msgbox ("text")
end if
end sub
 
S

SusanV

Thanks Rick, I was overcomplicating thigns as usual...
;-)

Rick B said:
Aircode...


sub... on click...
If IsNul([SomeField] then
Msgbox ("text")
end if
end sub




SusanV said:
How can I set a MsgBox if a form's field isn't filled in when a button is
clicked? (The form works off a temp table and this button populates a
permanent table and this field is required in the permanent table)

TIA,
Sue
Click to expand...
Click to expand...
 
Top