Hi i tried setting the 0 to null on the main table, do you mean use the combo on the form, if so the problem with that is the main table is from another database, the values you see is read only in the form so i want it to reflect the table, thanks through