Disappearing Records

[JUDO]

I have a combo box on a form, this combo box by the use of a select query shows all the relevant values in the drop down box from a table:mad.

My major problem appears to be that records that are selected in the combo box by way of the slect query seem to be disappearing from the table or part of the record is lost.

ANY ideas??

 

[Bee]

I have a combo box on a form, this combo box by the use of a select query shows all the relevant values in the drop down box from a table:mad.

My major problem appears to be that records that are selected in the combo box by way of the slect query seem to be disappearing from the table or part of the record is lost.

ANY ideas??

Do you have a value in your combobox that is Null?

 

[JUDO]

The combo box is built of a select query which in turn references a table with no null fields. (Except the additional record add at the bottom of all tables)

 

[Bee]

The combo box is built of a select query which in turn references a table with no null fields. (Except the additional record add at the bottom of all tables)

try to delete your query, save and open your combobox properties window and then write it again. Also, try to set the default value on the field that gets deleted to "" (nothing).

 

[JUDO]

Thanks for your help I will give it a go.