I frequently create a form to update a table. I create a query to include data from a different table. For example, the update table contains a foreign key pointing to the person table, from which I want to display first and last name. I include the name in the quey to display on the form.

Frequently, my nice form turns out to be not updateable. Can anybody advise me on how to create a query and form that will allow updates?

You are on the right track. Use a form and subform. Base the form on the person table, and base the subform on the table linked to the person table with a foreign key.

Then drop the subform on the main form in design view, and make sure that the parent and child fields are linked. Then you can add new people in the main form, and add items for the person in the subform.

If the query is from more than one table on your form, it won't be updateable.

Did that help?

mmcdonal

That pins it down for me. Much thanks.