Hi,
i have a main form called MainForm with FraudRef as the primary key. On the form I have a sub form called PolicyForm that is linked by FraudRef. On the subform there may be more than one record linked to the FraudRef and the primary key on the subform is PolicyNumber.
I would like to create a combo search field in the header of the subform to find a record based on PolicyNumber. I would also like the combo field to contain PolicyNumber, CustomerName, 1stLineofAdress and Postcode when searching.
Any thoughts on how I can acheive this?
kind regards,
Grant