Any Suggetsions? First Time doing this

[ChampionDuy]

I have a form which has a combo box on it, the user uses this box to pick a case and then the user can modify the corresponding case information. I would like to know the best way to go about doing this. What is the best way to link the combo box to the rest of the fields on the form, so that when a new value is picked in the combo box the rest of the fields on the form change with it. I assume that I need to pot some code on the After Update event of the Combob box. I have some Ideas on how to do this but I was just wondering if someone knew the most efficient way to do this. Thanks, any help would be appreciated

 

[Hayley Baxter]

The easiest way is to use the wizard step through this selecting the 3rd option available "find a record on my form based on the value I selected in my combo box"

Hay

 

[ChampionDuy]

Thanks

Thanks, I am an idiot, I dont know how I missed that on the wizard.