multiple if condition

[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

 

[AlCamp]

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

 

[ACG]

If isnull(me.firstname) or isnull(me.Lastname) Then
If isnull(me.BusinessName)
Exit Sub
End If
End If
DoCmd.OpenForm "NextForm"