combo box: to control the navigation buttons

[PrittyMe143]

i got a form with a subform. from the main form, i have a combo box. if i change the value of the combo box, the entries in the subform would also change because this combo box is linked to a certain field in the subform. but... the record on the main form is altered. what i really want is if i change the value in the combo box, the main form would forward to the record that is being specified in the combo box. meaning, the combo box will control the navigation button (some sort of) of the main form. is it possible?

 

[PrittyMe143]

I found the SOLUTION!

First, add a combo box and when the wizard appears, choose 'Find a record on...' then just continue with the wizard.

The problem that arises next is that when you load the form, the combo box is empty and the record displayed is the first record.

To solve that, on the Default property of the combo box, type the field that supposedly its control. For example, if thet combo box looks for the ID number then the Default property value should be [ID].

Hope this helps!!!!!!!