Validation rule on VBA

[Vugar]

HI,


How I can write it "<=Nz(DLookUp("[SumOfQuantity]","[TotalInStock]"," ItemID = " & [ItemID] & "And [Status ID] = " & [Status ID]),0)" on VBA.

thanks

 

[Vugar]

Could you please help with this issue

 

[jdraw]

You can review Allen Browne's tips. But I would consider using vba code in the beforeUpdate event of the form where you capture the data.

 

[James Deckert]

I think you'd get more responses you you gave more info on what you're trying to accomplish. Maybe jdraw understands, but I don't.
If you're getting a syntax error, it looks like you have quotes within quotes. Maybe they need changed to apostrophes? Don't know since I don't understand the big picture.
"<=Nz(DLookUp('[SumOfQuantity]','[TotalInStock]',' ItemID = ' & [ItemID] & 'And [Status ID] = ' & [Status ID]),0)"

 

[Vugar]

It's validation rule set in the form field on Stock DB.
And that rule for outgoing, so if outQuantity must be lower from incominqQuantity
I would like to learn it's possible to write this code on VBA.