You can reference a textbox from a form in a query, so long as the form is
open at the time:
SELECT Forms!NameOfForm!NameOfTextbox AS TheValue,
TableName.Field1, TableName.Field2
FROM TableName;

Signature
Ken Snell
<MS ACCESS MVP>
>I am working on a project to figure cost to install Millwork
> I have a form where I enter the cost to install each item on
[quoted text clipped - 7 lines]
>
> Thanks for your help
Jan Baird - 27 May 2008 20:52 GMT
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.