change field property of table

[primerov]

Field property in a table

I have a field called Quantity where the Required property is set to Yes.I want to change it to No.
In other words, I need to change in the table "order details" the required property of the field Quantity from Yes to No, but through code.
I can easily change this property by opening the table in design view,nothing easier than that.I need however to ship this function to different users in the

country, and these users cannot open the table "order details", the table being protected. So i will ship them a form with the code through an OnClick event.
I hope i am clear with what i want to do and will be grateful for any help.

 

[danvlas]

Try this:

CurrentDb.TableDefs("TableName&quot("FieldName&quot.Required =False

HTH

Daniel Vlas
Systems Consultant
danvlas@yahoo.com