Details portion of the Main form to set to no edit

[BPBP]

How do I set the details portion of the main form to be "no edit" but still have the combo boxes in the header of the main form able to key in data to get the correct record?

I'm trying to make the form & subform records just for viewing only but the records are searched by the combo box in the header.

I could set the form as no edit, but this also disables the use of the combo box to search records.

Any suggestions?

Thanks.

 

[HiTechCoach]

Will the form always not allow edits? If you never want to edit the data, then set the form's Recordset Type Property to "Snapshot"

If you do want to allow edits, I do this by setting the Locked property to Yes for the control that I do not want the user to edit. I use an edit button to unlock the controls using VBA code to set the property to false.

 

[BPBP]

Will the form always not allow edits? If you never want to edit the data, then set the form's Recordset Type Property to "Snapshot"

If you do want to allow edits, I do this by setting the Locked property to Yes for the control that I do not want the user to edit. I use an edit button to unlock the controls using VBA code to set the property to false.

Yes its just for viewing and no edits. Thanks i tried it and its good.