Run Update Query on Current Record in Form

[c3pse]

Hi,



I am have a little bit of experience with Access but I need some help with a database for a school IPT assignment.

Basically I have a button on a form that I want to run an Update query on the currently displayed record.
I have been using this SQL to update but it updates all records.

UPDATE BlueSlips SET Detention = False;

I have tried to using code #2 but it comes up with Compile Error and highlights the Private Sub line.

Code #2

strSQL = strSQL & "UPDATE BlueSlips SET Detention = False; WHERE BlueSlipsID = " & Me.BlueSlipsID

Any help would be appreciated
Thanks.

[Datagopherdan]

Try this. I'm assuming that "Detention" is a Yes/No field.

CurrentDb.Execute "UPDATE BlueSlips SET Detention = 0 " & _
"WHERE BlueSlipsID = " & Me.BlueSlipsID

[weekend00]

You can include field "Detention" in the form (if don't want to show this field, hide it).
and code like this:

detention=false

[c3pse]

You can include field "Detention" in the form (if don't want to show this field, hide it).
and code like this:

detention=false

Could you elaborate on this please.

Thanks

EDIT: I have used this but now it comes up with 'This recordset is not updateable'. I have tracked this to the query because as I have tried to uncheck the box it comes up with the same thing in the status bar.