Hey everyone.

I have a form within a database i set up which can be auto populated on the whole by selecting a code from a drop down list which works fine. The table that generates this information has a filed called TRUST which originally had no information in it so i created a another field (combo) with a list of options to choose from.

The main form populates and saves back to the table when a code is selected with no issues but the TRUST field will not save UNLESS a code is selected which may not always be an available option.

The drop down combo for trust appears in both the form and table but unless that original code is selected it will not save at all. can anyone tell me what i have done wrong please?

It's like the form won't activate at all unless that original code is selected and i tried a dummy code but it just populates the form with data from the first record in the table

Thank you

Mykal