[AccessD] [dba-VB] Multiple-step operation generated errors - check each status value

A combo box bound to an Integer field will have a 0 after the user deletes
the entry.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Friday, January 09, 2004 5:24 AM
To: dba-vb
Cc: accessd
Subject: [AccessD] [dba-VB] Multiple-step operation generated errors - check
each status value


To all,
 
I have a Visual Basic 6 FE which is connecting to a SQL Server 7.0 BE.  One
of my fields is called EthnicOrigin which is a TinyInt data type, which also
allows Null.  The control on the form is a DataCombo, with the list field
being Ethnicity and the BoundColumn being EthnicityID.  When a user selects
an Ethnicity all is well no problem with updating etc as the EthnicityID is
entered into the Field and the DataCombo display the Ethnicity.  If the user
deletes the entry from EthnicOrigin then when the record tries to update I
get the error 
 
Multiple-step operation generated errors - check each status value
 
Below is the code for updating:
With rsPersonnel
If (frmOrrPersonnel.PVEthnic <> "") Then
.Fields("EthnicOrigin") = frmOrrPersonnel.PVEthnic.BoundText
Else
                        .Fields("EthnicOrigin") = 0
End If
.Update
End With
 
Can anyone tell me what I am doing wrong ?
 
Thanks in advance for any help as this is really starting to frustrate me.
 
Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime _______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com