[AccessD] Very Strange Problem with Access

You know Gustav, that might be the problem.  The user was talking about MDAC
versions but I don't think that they can modify the user's machine in any
event.  It's a military installation.

But I disabled the problem.  I tracked it down to any use of that combo box.
If the combo box wasn't accessed while the form was open, the form closed
correctly.  So right before the DoCmd.Close I had the user insert
cboBuilding.RowSource = "" and the problem went away.

I'll forward your idea to the user, though.

Thanks again.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, September 24, 2004 9:28 AM
Subject: Re: [AccessD] Very Strange Problem with Access


> Hi Rocky
>
> Check - or just go ahead and update/reinstall - the MDAC.
>
> /gustav
>
>
> > It runs fine on every box its ever been on.  But on this one box, when
the user exits from frmRoom and the Main Menu is displayed, they get an
"Enter Parameter" box prompting for
> > Forms!frmRoom!txtClusterID as if the combo box is being requeried.  But
at this point the form frmRoom is closed. I've stepped through the code and
the parameter prompt appears AFTER the .Close.
>
> > qryBuildingByCluster is only used in one place in the system - as the
row source of the Building combo box in frmRoom.  We checked references and
they're identical to the client's laptop on which
> > the program runs fine - can't duplicate the error.
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>