AllowEdits False and a combo box

[MartyO]

Hi there.
I have a form that I open in read only mode, by setting the
Me.AllowEdits = False on the forms Current event. And then when they click
on an edit button, I set Me.AllowEdits = True. That works great.

Except that, because of the form being in read only mode, my combo box
control that let's the user lookup a particular record doesn't work. Is
there a setting that I can use just on the combo box to make it work when the
form's allowedits is set to False?
thanks in advance!!
Marty

 

[Dirk Goldgar]

Hi there.
I have a form that I open in read only mode, by setting the
Me.AllowEdits = False on the forms Current event. And then when they click
on an edit button, I set Me.AllowEdits = True. That works great.

Except that, because of the form being in read only mode, my combo box
control that let's the user lookup a particular record doesn't work. Is
there a setting that I can use just on the combo box to make it work when
the
form's allowedits is set to False?
thanks in advance!!

One approach is to use the combo box's Enter event to set AllowEdits to
True, and use its Exit event to set AllowEdits to False again.

 

[MartyO]

Perfect! Thanks so much!

One approach is to use the combo box's Enter event to set AllowEdits to
True, and use its Exit event to set AllowEdits to False again.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)