Automatic Field Entry Contradictions

[nice_beaver]

Is it possible to ensure that if a particular field has a specific value, ie, 'yes' then the reaminaing fields on the page are automatically set to 'no' by default?

If No is selected in the field in question then this would subsequently allow the other fields to be set to any value.

Thanks in anticipation

 

[FoFa]

If they are all radio type buttons, that is what a frame group does for you.
How ever if you are trying to control if other fields can be used or not, disabled is better.
If you have to have specific things like NO in them, you would need to check the value of the first field (yes/no, checked/not checked - what ever) when you load each new row (given this is on a record), and adjust the other fields accordingly in VBA would be the best option.

 

[Mile-O]

It soudns like your table is suffering from a repeating group which you should eliminate by using the principles of normalization as you are wasting unnecessary space.

The proper method here would be to create a new table with two fields: an autonumber key and a text field listing each member of this group. i.e. Person1, Person2, Personn so that in the new table there is a record for each of the elements of the group.

Then, in your original table you can remove all the unnecessary fields, add only one that will hold a number. In this field goes the relevant key from the newly created table for each of your records in the main table.