Form to feed report

[Guest]

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

 

[Brendan Reynolds]

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

 

[Guest]

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