Only Allow Edit of Specific Fields

[Guest]

The subform I am working with, has about 12 fields per record. I want to
prevent users from editing 9 of those fields, but allow them to edit the
other three as well as adding new records. The three fields I want to allow
them access to are Yes/No checkboxes which will at the time of entering the
data be unchecked, but at a later date need to be edited to Yes.

I've tried a few combinations of properties on the form and controls, but
haven't found a solution.

How can I prevent the editing of most fields in a record, while allowing
specific fields to be edited?

Actually the fields would only need to be edited one time each after the
initial data was entered. Is there any way to restrict editing to a specific
number of times?

Any assistance will be greatly appreciated.

 

[Guest]

A couple of suggestions:
If I understand the question correctly, go to 'properties' of each subform
control, select 'data', select 'Enable' = No. All fields will be visible, but
only the 3 will be editable.

Or, base the subform on a query; uncheck the 'show' box in the query. Your
subform then will only have the controls available on the form. Fields within
the query will not be visible and not editable.

 

[Guest]

Thanks for the suggestions, but those options seem to restrict any new
entries as well. I didn't describe my situation very clearly.

Basically, when boiled down my subform has the following controls which are
tied to fields in two linked tables. The subform is used to enter data into
those tables, with every record requiring entry for Fields 1-6. The main form
only performs and displays calculations and totals of the number fields of
the subform.

Control 1 = Number Control 2 = Date
Control 3 = Text Control 4 = Number
Control 5 = Number Control 6 = Lookup
Control 7 = Yes/No Control 8 = Yes/No
Control 9 = Yes/No

The user needs to enter the details using Controls 1-6 for every new record,
but should not be able to edit any entries using those controls for
previously entered records. They should be able to make selections for
previous entries using controls 7-9. If at all possible, they should only be
allowed to make a single selection using controls 7-9 with no capability of
further alteration.

For example:

- entering a new record
Control 1 = ### Control 2 = ##/##/##
Control 3 = abcdefg Control 4 = ###
Control 5 = ### Control 6 = selected from pull down
Controls 7 - 9 = (no selection made, left at default)

- editing record
Controls 1 - 6 = (no editing allowed)
Control 7 = select yes
Control 8 = select yes (or leave to be edited at a future date)
Control 9 = select yes (or leave to be edited at a future date)