Enable CmbBox when frm may not be edited

[Real Wally]

Users of my DBs get view/edit privileges on forms based on their loginname.

If fPrivileges("E") = True Then
Me.AllowEdits = True
Else
Me.AllowEdits = False
End If

Works fine except that when somebody is not allowed to edit the form the comboboxes to quickly find a record are also disabled.

I've tried Me.NameCombobox.Enabled = True but that doesn't do the trick.

Is there a way around this?

Thanks,

Wally

 

[bjackson]

you could try to loop through each control on the form,locking everything except combo boxes, rather than using allow edits
for the form.

 

[Real Wally]

Thanks.
Yes, I could do that and if that's the best solution I will.
I was hoping there is a possibility to 'overrule' the disable code in individual cases.

Is there such a code?

 

[bjackson]

not that i know of
Perhaps some one else in this forum may have a better answer for you