I am trying to use the lookup table to create a drop down of physician names from a physician table. I want the drop down to be limited to just the physicians that the user logged in has access to, defined by the OwnerID settings I have set in the security settings. I have a security table that contains the username, password, and UserID. My physician table also has the field UserID, both of those are linked in the security settings. I have tried to base my WHERE statement on the example given on the WHERE dialog box: " UserID = '" & Session("UserID") & "'" The drop down box ends up blank with nothing in it. I am using Microsoft Access and know nothing about code.