I have a form named Main with a combo box named Combo14 on it.
Combo14 is a look up of 2 columns from a table Named Narratives.
The 2 columns of Comb14 are: 1) Name 2) Company
I need to open a form Named List where column 1and 2 of combo14 on the Main Form are equal to the fields Name and Company from the Table Narratives.
in other words
I have several narratives that as users create the narrative they enter the first name of the user and also the Company that the user is from. this is what makes up the 2 columns of combo14.
so now i would like to see all of the narratives for a certain employee. There may be several David's all from different company's, so by using combo14 I hope to be able to select David from ABC Company or David from XYZ Company.