Forms

  • Thread starter Thread starter Tina
  • Start date Start date
T

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?
 
Tina said:
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?
Click to expand...

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.
 
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
 
Back
Top