is locked vs. after update

[BMoroneso]

Hi everyone,
I need to make some fields on a form locked. The method I am using is
naming each field and subform that need to be locked. In the majority of
cases, this works fine. The exception is when there is an event tied to the
combo box that needs to be locked. Is there a way to disable the 'after
update' event while the combo box is locked? The error I receive is "object
doesn't support this property or method."
Thanks in advance!

 

[Jeff Boyce]

Are you using the .Locked property or the .Enabled property?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BMoroneso]

I have tried both with the same result.
thanks!

Are you using the .Locked property or the .Enabled property?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[boblarson]

What code are you using that gets that error? It shouldn't matter as far as
the event goes, so I suspect something completely different.

Post your code and the line it highlights as an error.

--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Rick A.B.]

Not sure I understand your problem. If the combo box is locked the
Afterupdate event should not fire. So are you saying your having
problems locking the combo box? This works fine for me.
Me.ComboBoxName.Enabled = False

Hope that helps.

Rick