You haven't specified in what way it doesn't work.
Have you tested each criterion by itself, so that you know that the problem
lies in using them together?
For example, many textboxes which appear empty actually contain a blank
string, so they fail the IsNull test.
"Lee-Anne Waters via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:4f******************************@AccessMonste r.com...
hi,
hopefully an easy one for someone.
how do i specify two sets of critera in an if statement
for example
if isnull(me.txt27) and me.txtfld = "4" then
msgbox "You must enter a serial number"
end if
i just cant get this work..
thanks
Lee-Anne
--
Message posted via http://www.accessmonster.com