open one form from a command button but another if the user clicks 'x' instead.

[kelkan]

I have several forms in my database to guide a user to specific information. Each one of these forms is setup to close the current form and open the new form after a clicking a command button. This works great if the user uses the command buttons throughout; however, when the user closes a form by clicking the 'X', the form closes and nothing is opened. I want the user to use the command buttons and navigate the database that way. Is it possible to setup a message box to open if the user clicks the 'x' instead of the command button? I tried the on close event but I want the form to close if the command button is selected and the intended form to then open. suggestions?

[pbaldy]

Why not just hide the X? If you want to leave it, you're probably looking at a form level variable and the unload event, which can be cancelled.

[kelkan]

how do you hide the x?

[pbaldy]

Look at the properties of the form. On the format tab if memory serves.

[June7]

Yes, it is the CloseButton property on Format tab - set it to No. The X won't go away but it will be disabled. Have you also disabled the right click shortcut menu?