I have a form that has a Union query behind it so I can get everything from one table and everything from the other table. When I Filter by Form, the dropdown lists have Is Null and Is Not Null for the dropdown options. When I was using a query (behind the form) that didn't have the union query, it worked but it wasn't giving me the records from the other table that didn't have an outer join. Is there a way to get what a want using a Union Query? Thanks for your help.