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