Insert into table

[Mclaren]

I have the following code :

Qst = "INSERT INTO tbl_Activation (ID, Status, PCname) " & _
"VALUES (1,'Yes','test');"
CurrentDb.Execute Qst

this inserts text into my table just fine, however i would like for the code to insert text that is in a unbound text box on my form. in essence where the word "test" is, i would like to put the text in the text box, i just have no idea on how to reference the text in the text box. The text box is called "txtPcName"

[RuralGuy]

Qst = "INSERT INTO tbl_Activation (ID, Status, PCname) " & _
"VALUES (1,'Yes','" & Me.txtPcName & "');"
CurrentDb.Execute Qst

[Mclaren]

Qst = "INSERT INTO tbl_Activation (ID, Status, PCname) " & _
"VALUES (1,'Yes','" & Me.txtPcName & "');"
CurrentDb.Execute Qst

yyeeeehaaawww. been battling for a while with this.

thanks man, have a beer on me....

[RuralGuy]

Glad I could help. Are you ready to follow the link in my sig and mark this thread as Solved?

[Mclaren]

my bad, thought i had...