multiple if condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have three fields firstname, lastname and business name.

I want to have a conditional statement that stipulates, if a last name and
first name are provided, then continue to next screen, or if business name is
provided then go to next screen, otherwise, you cannot continue.

Any help would be great,

Thanks
 
Carlee
Lots of ways to do it...
If Not IsNull(LastName) and Not IsNull(FirstName) or Not
IsNull(BusinessName)
Then
'go to next screen
Else
'stop or I'll shoot!
End If
hth
Al Camp
 
If isnull(me.firstname) or isnull(me.Lastname) Then
If isnull(me.BusinessName)
Exit Sub
End If
End If
DoCmd.OpenForm "NextForm"
 
Back
Top