Open a form from a combo box

[masanovic]

I have populated a combo box which does so after initialising. How can I open a form based on the selection the user makes in the combo box?

Example: Select "June2008" in combo box and form called June2008 opens.

 

[sxschech]

If this is for MS-Access,

Place this in the After Update event of the combo box:

Hard coded, would look like this:

DoCmd.OpenForm "June2008"


As a variable:

DoCmd.OpenForm Me.NAMEOFComboBox

Replace NameOfComboBox with the actual name of the combobox

 

[masanovic]

Ive done it now. Thank you very much for your reply.