Locking (disabling edit for) a row in continuous form

[Jeff A via AccessMonster.com]

Hi!

I'd like some help. I have a continuous form bound to a transaction table.
What I'd like to happen is that for certain rows/records, the user won't be
able to edit them if the Post field of that record is flagged as true.
However, the user should be able to add more records and/or change/delete
data of unposted records.

Thanks in advance!

Jeff

 

[Allen Browne]

Try adding this line to the Current event procedure of the form:

Private Sub Form_Current()
Me.AllowEdits = Not Nz(me.Post, False)
End Sub

You might want to set the form's AllowDeletions as well.

 

[Jeff A via AccessMonster.com]

Thanks Allen!

Just a related question: I'd like to change the backcolor of the controls of
the row if the Post field is flagged as true. I tried doing this with the
Current event but the rest of the rows change color as well depending on the
current row. Any suggestions on how to do this?

 

[Allen Browne]

Use Conditional Formatting (Format menu in form design view):

Expression ... [Post] = False

Assumes A2000 or later.

 

[Jeff A via AccessMonster.com]

It works! Thanks again

Use Conditional Formatting (Format menu in form design view):

Expression ... [Post] = False

Assumes A2000 or later.