Is there a way to disallow edit on the form

[Guest]

Is there a way to disallow edit on the form but allow edit on one of the fields
like a combobox ???

 

[Dirk Goldgar]

Is there a way to disallow edit on the form but allow edit on one of
the fields like a combobox ???

If the combo box is bound, then the only way I know to do this is to set
the form's AllowEdits property to Yes, but set the Locked property to No
for all controls except that one combo box. If the combo box is
unbound, then that approach would still work, or you could make the
form's recordsource nonupdatable; say, by adding the DISTINCT keyword
to the query.