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.

You can place a combobox on your form that is based on the query that you speak of. Using the wizard, one of the screens you come to will ask what you wish to do with the value in the combobox. Choose the option that allows you to save it to a field and choose the field from the dropdown that you wish to populate.