Close command asking for criteria ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a fairly simple form with a 2 user inputtable date fields, a [Start
Date] and [End Date].

I then have 4 list boxes which will then display different data based on the
dates entered.

This form does nothing but display info, no data can be altered.

The problem I am having is when I close the form, using docmd.close, It
appears that I am getting the listboxes asking for my date criteria. I have
checked EVERYTHING and can see no reason why it would give me this message
when I am closing the form. I have nothing that runs on close and the date
fields are both filled out.

It appears that the form is closing itself and then somehow trying to
refresh the listboxes.

Anyone have any ideas?

Thanks
 
Lythandra

This sounds like a problem I ran into before, involving using DoCmd.Maximize
when the form opened. If you've used this command, try adding DoCmd.Restore
when the form closes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
That worked.

Interestingly enough I'm not using a docmd.maximize on the form but it
worked anyway.

Thanks, I would have probably never figured that one out.


Jeff Boyce said:
Lythandra

This sounds like a problem I ran into before, involving using DoCmd.Maximize
when the form opened. If you've used this command, try adding DoCmd.Restore
when the form closes.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Lythandra said:
Hi,

I have a fairly simple form with a 2 user inputtable date fields, a [Start
Date] and [End Date].

I then have 4 list boxes which will then display different data based on
the
dates entered.

This form does nothing but display info, no data can be altered.

The problem I am having is when I close the form, using docmd.close, It
appears that I am getting the listboxes asking for my date criteria. I
have
checked EVERYTHING and can see no reason why it would give me this message
when I am closing the form. I have nothing that runs on close and the date
fields are both filled out.

It appears that the form is closing itself and then somehow trying to
refresh the listboxes.

Anyone have any ideas?

Thanks
Click to expand...
Click to expand...
 
Back
Top