How to open the form in Design view from 'Notinlist' event?

[HiTechCoach]

I need open the form in Design View from a combobox's Notinlist event. Any tricks?

Note: When you compile your database into an ACCDE ( MDE from 2003 and earlier) you can NOT enter design mode for a form.

I always use a split database with aACCDE/MDE front end for ALL users. I would urge you to do the same.

I would only recommend using a value list for a combo box if the list NEVER changes. I almost always use a table for the look up list values. IMHO, it is a "Best Practice" to use a table if the list can ever change.