Form to feed report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NoviceIan - 11 Oct 2005 15:20 GMT

Hi,

I've got a form which allows users to select a value from a combo box then
run a report based on their selection. However when the report opens it
minimizes despite the macro including a maximise setting.

Any ideas why this is happening?

Ian

Reply to this Message

Brendan Reynolds - 11 Oct 2005 16:07 GMT

My guess would be that some code (or possibly a macro) is attempting to
minimize the form, but is minimizing the report instead.

Look (probably in either the Click event of the command button on the form
or in the Open event of the report) for a call to DoCmd.Minimize. Try
placing a call to DoCmd.SelectObject before the call to DoCmd.Minimize, to
make sure the form is the active object when the call to Minimize is made.
For example ...

DoCmd.SelectObject acForm, "frmTest", False
DoCmd.Minimize

Signature

Brendan Reynolds

> Hi,
>
[quoted text clipped - 5 lines]
>
> Ian

Reply to this Message

NoviceIan - 12 Oct 2005 10:07 GMT

Hi,

Checked but there does not seem to be any such code. However I've set the
form to dialog which seems to make a difference. When I changed the boder to
sizeable it worked fine. Any ideas why and how I can get around this?

Ian

> My guess would be that some code (or possibly a macro) is attempting to
> minimize the form, but is minimizing the report instead.
[quoted text clipped - 17 lines]
> >
> > Ian

Reply to this Message