In one form i have a combo box showing 2 columns - client name , policy # (policy # cannot have duplicates). Upon selection a new form form opens using policy # as the linked field between the 2 forms. Unfortunately the original combo box only allows 1 bound column. How do I show both columns from the combo box in the newly open form? (i have a client table -client name has no diplicates and a policy table where policy # has no duplictaes - but one client may have multiple policies)

If the first form remains open then code like this in the second form should work for you: Me.ClientName = [Forms]![Form1Name]![ComboName].Column(0)