Update Field!

[blindlemonray]

I am trying to update a field in a table with text when a box is checked on a form. So you tick the box and field is updated with "test" for example and then when you untick the word is deleted. I have this code in place but I keep getting a write conflict.

If chk_box = True Then
Me.field_name = "test"
ElseIf chk_box = False Then
Me.field_name = " "
End If

Any Ideas???

 

[lespaul]

in what event do you have this code?

Leslie

 

[blindlemonray]

Its On Click!

 

[dhookom]

On Click of what control? Also, what is the exact error message? You may need to use the after update event rather than the On Click. Is there a control source of Me.Field_Name? Why would you place a single space rather than setting the control to Null?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]