How to use combobox to open specific form in Ms Access

Question

How can we open specific form based on what we click in the combo box? I tried using macro but it only can be used for 1 value of the combo box only (cannot assign specific form for all value of combo box)

Answer 1

1. Goto to Combo box properties and select Macro builder
2. Using Macro you can define all conditions and respective actions.