Is there any way for me to get data from a form's text box into an append query? I need to get the text from the forms text box, and have it under the criteria in the append query, but every time i try the build function, it doesnt work.

Example: the Query
Field - blah
Table - blah
Append to - blah
Criteria - [Forms]![Form1]![txtBlah]

I get an error saying: MS Jet Database does not recognize [Forms]![Form1]![txtBlah] as a valid field name or expression.

Any help would be greatly appreciated. Thank you.

Could you please post the SQL of the query. Should look somat like this:::

INSERT INTO AppendToHere
SELECT
FROM tblChangesPriority
WHERE (((tblChangesPriority.PriorityID)=[test]));

Oh nevermind i found something online that helped me. Here it is:
http://support.microsoft.com/?kbid=209778
It doesn't grab any data from the form, but i guess i dont really need it to in this case.