Locking records problem

[Meltdown]

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

 

[shadow9449]

How about setting the individual data fields to Locked?

SHADOW

 

[Meltdown]

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

 

[shadow9449]

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

 

[missinglinq]

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!