title: Access: Search Multiple Table and Return Unique Customer Form
body: <p>I am a complete noob with databases but have managed to design one for my friend who runs an insurance agency.  I am almost finished but I just need to be able to enter a search field.</p>
  
  <p>Basically, I have a customer form with all the customer's contact details and then subforms showing the different types of insurance policies (motor, home, medical, etc)  The customer form links to a customer table, the subforms link to tables (motor, home, medical,etc., one table per subform)  All tables are linked through the field CustID</p>
  
  <p>What I need to do is to search each subform for a unique policy number then return the customer form relating to that policy number.  Or to paraphrase; search for the policy number amongst all the tables (motor, home, medical, etc), locate the CustID then bring up the Customer Form relating to that CustID.</p>
  
  <p>Any help would be appreciated as I have spent days searching the web trying queries and union queries and haven't found any responses which would bring up the form.  I am obviously missing something</p>