Hi all,

I am currently playing with script to bring up a lookup dialog, which will change depending on the datagrid being clicked. This is fine, and so far I have:

strFeeType = Mid(Sender.Name, 8) & " Pass"
Set Lookup = Application.BasicFunctions.LookupItemWithConditionByID("EVXCOURSEFEE:CourseFees",True,"EVXCOURSEFEE:EVXCourseID",courseID,"=",strFeeType)

This works fine for Grids that represent one specific type of Fee (Bus Pass, Visitor Pass, etc.), but I also have to script for an 'Other' Grid, which holds several types at once. My question is, is it possible to achieve something like the following:

Set Lookup = Application.BasicFunctions.LookupItemWithConditionByID("EVXCOURSEFEE:CourseFees",True,"EVXCOURSEFEE:EVXCourseID",courseID,"NOT IN","(Bus Pass, Visitor Pass, Meal Pass)")

Any pointers/insights much appreciated!

EDIT:

Never mind, found Serg Zhidelyov's comments in the Total Control Lookups article, the below works just great.

Set Lookup = Application.BasicFunctions.LookupItemWithConditionByID("EVXCOURSEFEE:CourseFees",True,"EVXCOURSEFEE:FeeType",courseID," NOT IN ('Bus Pass','Visitor Pass','Meal Pass') AND EVXCourseID = ","")