Update current Record only (1 Viewer)

[Number11]

Hi, So i need to have an option to update the record displayed on a form only.

I would need to have an append query to remove users name and refresh the form so the records is un allcoated?

 

[theDBguy]

Is the form read only? Does your record have an ID field? Did you mean you need an UPDATE query, not APPEND?

 

[Number11]

ok think ii found it

when button is click this code will clear the field
Me.txtUser = ""

then refresh query