Turn off required property via code

[Randoz]

I am trying to write an if/then statement to disable the "Required Property" and then to enable it after a record is saved. Almost like the visible and locked code.

[Scott Price]

You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.

MODERATOR.

[Scott Price]

I am trying to write an if/then statement to disable the "Required Property" and then to enable it after a record is saved. Almost like the visible and locked code.

Wouldn't such a code negate the need to have the Required Property set at all?

In other words, why?

Regards,
Scott

[Randoz]

I have field that is required uless another field is filled in with certan text.

[Scott Price]

Well, I suppose you know that really doesn't answer the question :-)

You'll need to investigate the DAO Required property. Typing Required into your VBA editor window then pressing F1 will bring up context sensitive help on the keyword.

Good luck!

Regards,
Scott

[missinglinq]

Instead of having your field Required and then trying to change this, you need to strip the Required attribute, and use a validation routine to assure that the second field is filled in if the first doesn't have the required data. Something like this, where FieldB is the field that has to contain data if FieldA doesn't hold a certain value.

Private Sub Form_BeforeUpdate(Cancel As Integer)
 If Me.FieldA <> "This is the required text" And IsNull(Me.FieldB) Then
  MsgBox "FieldB is Required!"
  Cancel = True
  FieldB.SetFocus
End If
End Sub

Linq ;0)>

[Randoz]

Thanks Linq, that will do what I need to do.

[missinglinq]

Glad we could help!

Linq ;0)>

[NeoPa]

Another option is the Validation Rule property. That is there for exactly that purpose.