[AccessD] A2K:Change of Value Not working

Darren DICK d.dick at uws.edu.au
Wed Aug 27 08:53:14 CDT 2003


Andy you DA MAN

It was in the On_Open of a form
When I put it into the On_Load of the form...
"Thar she blows, Cap'n" - That was the answer
Thanks for the help

Darren


----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Wednesday, August 27, 2003 11:40 PM
Subject: RE: [AccessD] A2K:Change of Value Not working


> Hiya Darren
> Where's the code? What event proc I mean. I've had this on a report when
> putting the code in the OnOpen. But this is a form you say.
> 
> Andy Lacey
> http://www.minstersystems.co.uk 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
> > Sent: 27 August 2003 14:07
> > To: AccessD List
> > Subject: [AccessD] A2K:Change of Value Not working
> > 
> > 
> > Hello all
> > I am getting the "You can't assign a value to this object" 
> > error with the following code
> > 
> >     If Me.chkRequestorsToNote <> 0 Then
> >         Me.chkRequestorsSeen = -1   <====Error on this line
> >     Else
> >         'do nothing
> >     End If
> > 
> > Both Check boxes exist on the form. 
> > Both are bound to fields that exist in the underlying table
> > Yet when I make the checkboxes unbound this code works.
> > I have also tried the dot value property as well eg  
> > Me.chkRequestorsSeen.Value = -1 Still no good.
> > 
> > What am I missing?
> > 
> > Many thanks in advance
> > 
> > Darren
> > 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> > 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list