DBCombo Box - Urgent Help

[murphyt]

Hi All,
I am using VB6 Pro SP3 and just upgraded to SP4.
I have an application on a clients computer and users Access 97 on the Server.
The program has been running fine for approx. 2yrs until now.
I have a DBCombo which is populated from a Table in the Database and when the user makes a selection , that selection is stored in another table ( the main records ).
My Problem.
Out of the 25 selections only 16 that are selected will save in the main record table.
5 give error 524 - not allowed zero length string and the other four show a blank field in the combo.
Does anyone know what could be wrong ?
As my computer has two hard disks , I loaded the application to my main disk and the database to the other to simulate a network and all is fine !!!!
Please help.
Regards,
Trevor

[Gen-X]

The error is originating from Access and is caused because a record is being updated where a field that is set to "Do not Allow Zero Length" has no value.

Access spits at this because it has been told not to accept records that are "NULL" for this field.

I would be having a look at the records for the 5 that cause errors and check each field and your code for exactly where it copies it across. Somewhere in there something is either being left as NULL or being set to NULL for some reason

This can happen if a combo box does not have a current selection (ie cmbCombo.listindex = -1) as the Text attribute should be NULL when this is the case.