Forms

[Tina]

If I'm using a form to update tables, can I use a query
for all the tables involved or would it be better to use a
subform for each table that needs to be updated?

 

[Rick Brandt]

If I'm using a form to update tables, can I use a query
for all the tables involved or would it be better to use a
subform for each table that needs to be updated?

The latter. Multi-Table queries are often rendered non-updateable and when
they are updateable there is a chance that the updates won't be applied in
the manner you expect.

 

[Niklas Östergren]

It´s better to create a query involving the tables you ne4ed to update and
set the query to be the recordsource of the form.

Depending on your table structure maby you have to create a mainform and one
or several subforms to be able to use only one form (containing subform´s).

It also depends on how many fields you need to update. If it´s a lot it
might be better to split it up into a couple of forms instead of having all
field´s in one form. It might get cluttered and difficult to read/use for
the user.

// Niklas