Does anyone know how I can customise whether various fields are saved eg.

If IsNull(x) then

(Save the Certificate number in the field in to another table not listed not featured in the form query)

Else

(Perform a normal save)

Cheers

Matt

Confucius style question receives same-style-answer:

Use unbound form.