Macro to go to a form

[Sean_Sean]

I would like to know how i can assign a macro to a button on a form that will take the user to another form based on the result in the combo-box.
Eg: If the combo-box says: "Eden Project" it will take the user to that record on another form. Any ideas?

 

[David R]

You might want to have your combo box use the Combo Box Wizard's #3 option, "Select records based on this value" or something similar. Then go into the code behind your combo box and edit to open a new form, instead of looking in the current one.

HTH,
David R