If condition (Access 2000)

Topic

New Reply

To the existing If conditions i want to add the condition If IsNull(TglUnitPrice).
The existing working conditions are as folllows If IsNull(Me!Quantity) And Me!cartons = 0 And Me.Parent!Customerid 123 Then
I get the error in the following expression when i wnated to add the next if condition:
If IsNull(Me!Quantity) And Me!cartons = 0 And Me.Parent!Customerid 123 And If IsNull(Me!TglUnitPtice) Then
How can i correct it ?

Reply | Quote

Replies

You shouldn’t repeat the word If. It must be used at the beginning of the instruction only.

Reply | Quote