Allow Edit and Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

For my form, I disabled Allow Edit
but now my search combo box cannot wor
is there a way around this problem
disallowing editing but still allowing me to search

Thanks for any help!
 
Change Allow Edits for the form to Yes, and change the Locked property for
each control on the form except the search combo box to Yes.
 
When the Form's AllowEdits is set to False, you cannot change the Value of
*any* Control on the Form including the unbound Controls, e.g. your Search
ComboBox.

You need to set the AllowEdit to True and set the Enabled = False and Locked
= True for all Controls (except the Search ComboBox). Alternatively, you
can set the RecordsetType of the Form to "Snapshot" which does not allow
edits.
 
Back
Top