Setting a Required field to Null

[spika71]

I have four combos on my form that are bound to four non-nullable (Required) fields in a table. The nature of the data displayed by the combos is such that when the user changes one of them, all the combos to the right become invalid and must be reentered (e.g. if the user changes combo 2, they must reenter combos 3 and 4) I figured the best way to force reentry of the combos is to reset them to Null. Because the corresponding fields in the table are Required, the user will not be able to save the record until they fill the fields that were reset. Now the problem is, Access does not allow me to set a control to Null if it's bound to a Required field. I'd prefer it to defer the check until the record is saved.

Is there a way to bypass the check and set a required field to Null, while at the same time keep the Required attribute so that the record can't be saved with Null's in the Required fields?

Any help will be appreciated

Vladimir

 

[scking]

Set it to "". I believe that will resolve your problem. Make sure that on the table verification for the field you include:
Not = ""

Steve King Growth follows a healthy professional curiosity

 

[downwitchyobadself]

Are your combos pulling from lookup tables? I always use a 0 ID value, with a <none> name. When combo2 triggers, you can reset 3 and 4 to 0, and then check against 0 before allowing the user to move off the record