Locking records problem

Meltdown

Registered User.
Local time
Today, 14:59
Joined
Feb 25, 2002
Messages
472
Hi all,

I need to lock records where the order date is more than three days old. I know I can do that with the OnCurrent event, setting it to Me.AllowEdits = False when needed.

The problem with Me.AllowEdits = False is that the button/controls cannot receive other updates or instruction, example: if the record is locked down with Me.AllowEdits = False then I can't use Me.MyCmdButton.Visible = false...this is what I need...to be able to lock down the data updating part of the form and still allow controls to respond to the likes of Me.MyCmdButton.Visible = false.

Hope I explained that OK

Thanks for any help
 
How about setting the individual data fields to Locked?

SHADOW
 
I had thought of that as a last option.

I was hopeing there might be some other option that could be applied at the form level.

Thanks for the reply
Melt
 
I had thought of that as a last option.

I was hopeing there might be some other option that could be applied at the form level.

Thanks for the reply
Melt

Yes, I meant at the form level. The on_current method would be great, as you suggested. You can conditionally tell it to lock the fields that show the data.

SHADOW
 
Me.AllowEdits = False prevents data in a record from being edited, it should make absolutely no difference in the formatting of controls! If this is truly happening then you have to have something else going on!
 

Users who are viewing this thread

Back
Top Bottom