I have a form based on a query. I would like one field on the form to be filled in automatically. It has the same info for every record. In design view, I placed ="xxx" in the field. The info was reflected in the form but was not reflected in the original table. Any ideas how to solve this. Thanks.

If I understand your problem correctly, believe you should place the XXX in Default Value when you design the table structure.

[This message has been edited by yimlingyu (edited 12-08-1999).]

You can either set the default value property in the field in the table, or the textbox in the form to "XXX".

HTH
RDH