Form Maximized causes problem

[Jim Franklin]

Hi,

This is very strange. I have a form with a number of combo boxes on it. The
form is normally maximised. When I click a Close command button (simple code
docmd.close) it should close the form. However, it starts to de-maximise
the form (i.e. not maximized) and promts me for a Parameter. The parameter
is required by a query which is the rowsource for one of the combo boxes.

This does not happen if I close the form using the Close Button in the form
control panel. What is even stranger is that it does not happen if I
manually de-maximise the form and then click my Close command button.

Any ideas anyone? Please? Help!!

Thanks as always,
Jim

 

[Liz]

Try this as Event Procedure on the command button:

Private Sub Close_Click()
DoCmd.Close acForm, Me.Form.Name
End Sub

Good Luck!

 

[Van T. Dinh]

It's a bug.

See the Microsoft Knowledge Base:

http://support.microsoft.com/?id=811860

 

[Jim Franklin]

Thanks Van - it worked!

Jim F.

It's a bug.

See the Microsoft Knowledge Base:

http://support.microsoft.com/?id=811860