I'm using a lookup table to make a selection for a person name which I limit by "Division = '" & Session("OwnerID") & "'" - which works great - I select the names from a huge list. I want to limit the list by choice of type for each name - either by a, c or s. I made a seperate lookup for the type and select Athlete (which is equal to a) and want the list to only show the athlete names so I make the name lookup depended on it - that works - but when I add WHERE "Division = '" & Session("OwnerID") & "'" to the mix I do not get any names - What am I doing wrong