Combo boxe to go on specific record

[L'apprentis]

Hi, I am having a problem using the combo boxe, I think it is an easy problem but I have been spending the all morning trying to find a solution with no success.
i am designing a form allowing to enter the different costumer information in our system. The costumers information are broke down in 2 tables TblCostumer and TblCostumerOffice where a single costumer can have many offices across the world. The form shows the main costumer with a subform showing the different offices location.
I wanted to use a comboxe on the main form allowing the user to go on the specific costumer page selected, I am just working with 2 fields for now CostumerID and CompanyName. The combo boxe is bound to CostumerID and is not allowing any change, I don't know if it is the right method because I would normally use combo boxe to change a field value not find a specific record. Should i use code in the after update event using the 'gotorecord' or 'findrecord' command?

 

[ColinEssex]

There is an option in the ComboBox wizard that allows you to "find a record based on Combo selection"

Col

 

[L'apprentis]

Hey Colin,
Well i've tried the wizzard and I couldn't see where I could set the option to go on a specific record. I am using access 2003, does that matter?

 

[L'apprentis]

It's strange if I try to create a comboboxe in the costumer form i have been using until now, the wizzard doesn't allow me to choose the option "find a record based on Combo selection" BUT if i insert the combo box just after having creating the form from scratch using a wizzard, I have the third option available to me. I really don't know why , I guess I shouldn't be to picky and it's working now so Thanks again.