Update active record through vba

Question

I have a form which the user will use to navigate through the db records.  I also have a command bar which has certain administrative buttons.  One of which need to change the status of the active record.

I did something along the lines of :

sSQL = "UPDATE tbl_ComInt" & _

                   " SET tbl_ComInt.projFin = True" & _

                   " WHERE (tbl_ComInt.projId=" & projId & ");"

            db.Execute sSQL, dbFailOnError

but this results in a 3218 record lock error.  I'm assuming because the user is actively on the record, so it is locked for me to make my update.

How would others suggest I make this work?

Answer 1

In that case, you don't need an update query. You can set the value directly:

Me.projFin = True

Answer 2

It is bound to the same table: tbl_ComInt, hence this is why I suspect I am experiencing this problem.

Answer 3

Is your form bound to a table or query, or is it unbound (i.e. no Record Source) and is everything done through VBA?