Using a forms combobox value

[jaycee]

Hi

I have several forms but all should be opened from an initial forms combobox.

ie
FrmInitial has CmbProduct which has 11 names ("Incident process", "Spares-QM only", etc etc)
What I require is that when the exit button (Cmdexit) is pressed then it should do the following.
Frminitial should save
Possibly an if or select statement that looks at the combobox, then selects the next form to open.
Frminitial should then unload.

Hope that this makes sense

Using Excel 2003