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 from the subform and find that value in the subform and go to that record. I need to have a combo lookup with values from the subform not the main form...
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