Lockdown a Continous Form

[Stemdriller]

Hi all,

I have a form with 3 Tabbed Forms within it. One of which is a Revisions form, which the user is directed too after every change to any of the other forms.

This form has todays date, reason for change and the current user. As there can be many entries it is a continous form.

When an entry is made and the user selects save I want the entry just made to be locked so that it cannot be changed by anyone other than the Database Administrator.

I have tried the After Update or On Change (Me.textbox.enabled = False) but it then disables everything.
So when the next entry is entered the textboxes are already disabled.

Any ideas please

Thanks

Gareth

 

[John Big Booty]

If you have the form on that tab as a Sub-form you can then set it's Allow Edit, Allow Deletions properties to False (No) and its Allow Additions property to True (Yes). The users can make additions put once that records looses focus it becomes locked.

 

[gemma-the-husky]

the easiest way is to do this

in the current event for the record

if me.newrecord then
allowedits=true
else
allowedits = environ("username") = "Whomever"
end if

however, note that this will also prevent any edits in non-bound controls such as combo-boxes etc. Is this any good?

 

[Stemdriller]

Thanks Both

I shall try and sort it later on today.

Many Thanks, once again

Gareth

 

[Stemdriller]

John Big Booty, when I sit back and think about your reply, it's so easy! I should've been able to sort that myself.

Dave, you reply however, I used elsewhere in other form, which improved the form no end.

Guy, many many thanks, don't know what I'd do without you and this Website

Gareth