Hi guys, any help you can offer with this one is greatly appreciated.

I have a relatively simple database consisting of two tables. The first stores Customer Details, the second stores Invoices for each Customer. The tables are joined in a 1 to many relationship via an Account Number field.

I also have a form based around Customer Details, with the Invoices displayed as a subform - all works fine.

Now what I'd like to do is place a Combo box on the Main form that contains a list of all Invoice Numbers (a field in the Invoices table) - when an Invoice number is chosen, I'd like the Form to display the Customer Details to which the Invoice belongs, then set the focus of the subform to the corresponding invoice/record number.

A sort of a Search on Invoice number facility really. Anyone help with this?

Cheers in advance,
Phil (not a programmer)