[AccessD] matching field error

Hello Andy,

All fields are empty, no zero or blanc space. The Field is a combobox with property Limit To List is set to Yes. The ID fields Record Source is a query. The query's Record Source is a table in which the ID field is a lookup combobox from an other table. 

Andy or the rest of the group. How is this possible.

Pedro




In antwoord op:

> From: "Andy Lacey" <andy at minstersystems.co.uk>
> To: "'Access Developers discussion and problem solving'"
> Date: Wed, 10 Dec 2003 11:58:31 -0000
> Subject: RE: [AccessD] matching field error
> 
> 
> No, well if it's empty it isn't zero I agree, but there's something going on
> here that's not obvious and I'm struggling to think what. Is there any way
> the field could have a blank space in it rather than Null?
> 
> Andy Lacey
> http://www.minstersystems.co.uk 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > pedro at plex.nl
> > Sent: 10 December 2003 11:33
> > To: AccessD at databaseadvisors.com
> > Subject: RE: [AccessD] matching field error
> > 
> > 
> > Hello Andy,
> > 
> > In the help function i saw what the error means. But it made 
> > no sence to me. You say: "Is there any way they could have 
> > zeroes or zero-length strings rather than nulls". When a 
> > field is empty i think there is nothing in it. How can it be 
> > that a field is empty but a zero is present??
> > 
> > Pedro
> > 
> > 
> > 
> >  
> > 
> > In antwoord op:
> > 
> > > From: "Andy Lacey" <andy at minstersystems.co.uk>
> > > To: "'Access Developers discussion and problem solving'"
> > > Date: Wed, 10 Dec 2003 09:10:22 -0000
> > > Subject: RE: [AccessD] matching field error
> > > 
> > > 
> > > Pedro
> > > The implication is that the you have Relationships defined with 
> > > referential integrity. You are saving a record with a test id which 
> > > doesn't match to a key value in the tblTest table. The odd thing is 
> > > that this shouldn't occur if the fields are Null. Is there any way 
> > > they could have zeroes or zero-length strings rather tha  nulls, 
> > > because that would do it.
> > > 
> > > Andy Lacey
> > > http://www.minstersystems.co.uk
> > > 
> > > > -----Original Message-----
> > > > From: accessd-bounces at databaseadvisors.com
> > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > > > Pedro Janssen
> > > > Sent: 09 December 2003 22:41
> > > > To: AccessD at databaseadvisors.com
> > > > Subject: [AccessD] matching field error
> > > > 
> > > > 
> > > > Hello Group,
> > > > 
> > > > i get the following error in a form, when i close it and the
> > > > field 'PrTestID' is empty:
> > > > 
> > > > The microsoft Jet database engine cannot find a record in
> > > > table 'tblTest' with key matching field(s) 'PrTestID'
> > > > 
> > > > 
> > > > How is this possible, because the field isn't required?
> > > > Al the ID fields in the form give the same error when they
> > > > are empty (and all aren't reqiured).
> > > > 
> > > > 
> > > > 
> > > > Pedro Janssen _______________________________________________
> > > > 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
> > > 
> > > 
> > _______________________________________________
> > 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
> 
>