I have a form that is based on a table. A text box in the form is used to fill the values for one of the fields in the table. I would like to use a value from a field in a query to fill in the value for the text box and the then field in the table. I have tried various ways but nothing worked. Any help would be greatly appreciated.