Audit form unbound fields

[CosmaL]

Hello to everybody!

I have the following problem:

I've a search form, with only one unbound text box. On the search button code, i look for the string in a union query which results appears in a subform.
On the main form, i've also placed 2 checkboxes which show the username and the computername (function results)

I'd like to audit the text in the textbox, username and computername in a table.

I've a table with this fields and i've used the following code:

Dim rstAudit As ADODB.Recordset

Set rstAudit = New ADODB.Recordset
rstAudit.CursorType = adOpenKeyset
rstAudit.LockType = adLockOptimistic
rstAudit.Open "AuditTable", , , adCmdTable

rstAudit.AddNew
rstAudit!SearchString = me.searchtext
rstAudit!username = me.username
rstAudit!Computername = me.computername
rstAudit.Update

rstcontact.Close

The result is that i don't have any record in the table.

Any ideas for solving this or trying a new stuff?

Thank you in advance!

Costas