Freezing a Form

[Naia]

My users have to fill out a work request form. Lately I have been having problems with a few users copying over forms they shouldn't. Is there a way I can lock out or freeze past forms? In other words, the form the user is filling out freezes when the form is closed. I also need past forms to still be visible, just preferably not edited by anyone except the administrator.

 

[rainman89]

By forms do you mean records? or the forms itself?

 

[boblarson]

I think you are meaning to lock the fields. You can go into the form's properties and set AllowEdits to NO and then have a button that you can click to run this code:

Me.AllowEdits=True

And then put

Me.AllowEdits = False

on the On Current event too to reset it back to locked when moving from record to record.

 

[rosito]

have u decide, already? I want my form dont resize (is this "freeze" too?!?!!)

 

[Guus2005]

have u decide, already? I want my form dont resize (is this "freeze" too?!?!!)

No. That's another thread. Pls create.

@Naia: Have you tried to set the form to modal?

 

[GaryPanic]

My users have to fill out a work request form. Lately I have been having problems with a few users copying over forms they shouldn't. Is there a way I can lock out or freeze past forms? In other words, the form the user is filling out freezes when the form is closed. I also need past forms to still be visible, just preferably not edited by anyone except the administrator.

quick route on this is
add a extra field on the underlying table ccalled fieldlocks have this as a yes/no option default no

now add this field to your forms and have properties visible no

now have if name of the yesno field = true then
the name of the fields on the form enable = false

then once a week runan=an update qry to trigger the no to yes
job done

 

[rosito]

if i set Format->Border Style->Dialog (not "Sizable") & Format->Moveable->No all is oki with my form ...like Access!!!