I have example of what i'm trying to do but with big problems. I'm not a great VBA programmer so try to make Access do the work where possible but i'm going wrong somewhere here.The database holds company information with a separate table for the related contacts in the company. A third table holds information about documents raised against the company but when a document is raised, the user needs to choose the contact they spoke to from the company (there will be only one). The form frm_customer in the front end is the one that i'm looking at. The subform is created from a query. The query should filter by the customer chosen on the form but doesn't. Can anyone see what's going wrong here please? This is a put together example as the real database has lots of sensitive data. I can't seem to add the database (it just sits there adding it!) but will try again once I've submitted the post.