Need Code for if control is not null, Please

I

Ivar Svendsen

Hello.


Try to put this code into the subform:



Sub Form_BeforeUpdate(Cancel as Integer)
if isnull(PaymentType) then
MsgBox "Need PaymentType"
Cancel = True
elseif PaymentType = "Check" and isnull(CheckNumber) then
MsgBox "Need check number"
Cancel = True
end if
end sub



..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top