Is there a way to lock a single record from editing?

[krazieddi]

I use the first record of my table as a blank when the form is opened. Users are supposed to use a drop down to navigate to a record for updating. Some users have populated fields into my blank that i've had to go in and delete.

I'm wondering if there is a way to prevent that first record from being edited.


Thanks all! Happy holidays!


-ed

 

[Mihail]

Private Sub Form_Current()
    If Me.ID = 1 Then
        DoCmd.GoToRecord , , acNext
    End If
End Sub

 

[krazieddi]

Mihail:

I'm new to access 2007. Where and how would i use that piece of code? What exactly does it do?


Thanks.

-ed

 

[Mihail]

Maybe someone else can explain, by using a better English than my one, "how to".
I can show you if you will upload the DB.
Convert it in 2003 version (mdb) before uploading.

 

[wallacealeco]

If the only reason you have a blank first record is to allow users to navigate to the correct record you,could create a new form ( perhaps called controlFRM) and put your drop down on it. When clicked this could open your original form at the correct record. No need for a blank record. Put a 'close form' button on your original form to allow users to easily get back to the controlFRM.
As your database grows (they always do) you can add to the controlFRM and it becomes the starting point for the whole database.