On Wed, 8 Sep 2004 15:27:55 -0700,
wrote:

How do I change this?

See Access help.
Click on Help + Answer wizard.
in the Search box, type:

When can I update data from a query?

Follow the links.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.