Originally Posted by Cronk
Why would you want to do this? I can't think of a situation requiring this.
Maybe it is a bit unusual . Let me explain .
I have a data table (eg Table 1) and the form for adding and editing records in this table. Certain fields in this table must be filled in, so for this fields the Required property is set to "Yes". This ensures that all required fields are filled.
Certain records in this table should be added from another table (eg, Table 2) , but this table does not contain all the information required in Table 1. For Table 2 I get data from another software application.
As the data in certain fields in Table 2 are missing , I have to manually set the Required property to "No" to add records in Table 1 by using an append query (if I do not do this , the data will not be added) , and after adding records again manually re-set it back to "Yes ".
So I would like to make users may download data from Table 2 in Table 1 and then just enter the missing data in Table 1, because this would greatly facilitate the work . So I'm looking for a way to change field propertiy Required with some VAB code.