I have a main form and a subform on the main form. What I need to be able to do is have a lookup combobox on the main form and choose a value and find that value in the subform and go to that record.

Thank you

If you have the sample Solutions.mdb installed there's an example in there.

Select "Sample Forms" from the top box and "Sales Totals" from the lower one.

Simon

I am sorry I need to have a combo lookup with values from the subform not the main form.