yes, a utilizing a subform is just one solution, and only better if it's
easier for you. just to clarify, i didn't suggest putting the combobox
control in a subform, but rather in an unbound mainform, separating it from
the original form which would become the SourceObject of a subform within
that mainform.

hth


"Paul" wrote in message
...
Thanks for your reply, Tina.

I did think of putting the combo box in a subform, but using Dirk's
suggestion of setting AllowEdits = True in the combo box's Enter event
seems
to be working. Even if it were in a subform, I'd still have to check
every
new record to see if the user is authorized to edit it.

Ok, full disclosure - there's another reason I wanted to avoid putting the
control in a subform. I'm lazy, and every time I try put a subform
camoflagued as a single control into a main form, I end up spending about
20
minutes wrestling with size and placement of the subform control to get it
just right for appearance's sake. So from that standpoint, it's easier to
just Allow Edits when you enter the combo box, and you're done with it.

Marsh has raised a concern if the record is Dirty, so I'm going to ask him
about that over in the other thread.

Paul