How is the best to do a multi column lookup? What I want to do is have 4 var edits on a form that each correspond to a column in a table as follows:
Col1(var1), Col2(var2), Col3(var3), Col4(var4) in each variable the user has the option to but in a value or leave it null and then I want to be able to lookup matches(where the column contains the value) and pulls up rows from the table. I know I could do multiple IFs and THENs but is there an easier way Tom Hart
