is locked vs. after update

  • Thread starter Thread starter BMoroneso
  • Start date Start date
B

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!
 
Are you using the .Locked property or the .Enabled property?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have tried both with the same result.
thanks!

Jeff Boyce said:
Are you using the .Locked property or the .Enabled property?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
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

__________________________________
 
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
 
Back
Top