Lock all field values except one in query results

[MichaelA]

I have a form that sets query criteria and runs the query. I would like to leave one field unlocked so that the data can be changed and update to the table. THe rest of the cells I would like to leave locked so they cannot be changed. Is this possible. If so, how?

Thank you!

[isladogs]

Yes. Lock each of the controls except one in the property sheet.

Or do that in code using Me.controlname.locked =true for each control except one.

Or use the tag property to do this. See http://www.mendipdatasystems.co.uk/s...ols/4594398114

[MichaelA]

When I lock the control for the combo box in the form, I can no longer select an option from the drop down list.

Yes. Lock each of the controls except one in the property sheet.

Or do that in code using Me.controlname.locked =true for each control except one.

Or use the tag property to do this. See http://www.mendipdatasystems.co.uk/s...ols/4594398114

[MichaelA]

I apologize. I need to be more clear. It is within the query results where I don't want changes to be made.

[isladogs]

You can't lock individual fields in a query. The whole query is either editable or its read only.

However locking individual fields can be done on a form using any of the methods I described
If you also want a combo to be selectable, don't lock that control.