J
Jalal
Why we cannot update database through forms built on one to many relations
tables?
tables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
If the form is based on a multi-table query, try opening the query. Can you
update the records in the query?
NO: For a list of possible causes, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
YES: Then some of the form properties are set wrongly.
Datasheet Type should Dynaset (not the Inconsistent Upates one.)
AllowEdits must be Yes.
If neither of those help, it may be to do with Access security, or Windows
permissions.
update the records in the query?
NO: For a list of possible causes, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
YES: Then some of the form properties are set wrongly.
Datasheet Type should Dynaset (not the Inconsistent Upates one.)
AllowEdits must be Yes.
If neither of those help, it may be to do with Access security, or Windows
permissions.
J
Jalal
It is a form based on to related (One to many) tables not a query based form
A
Allen Browne
I don't understand.
If the form is based on multiple tables, but not a saved query, then
presumably you have a SQL statement in the form's RecordSource? Open that in
Datasheet view, and see if the results are read-only.
If the form is based on multiple tables, but not a saved query, then
presumably you have a SQL statement in the form's RecordSource? Open that in
Datasheet view, and see if the results are read-only.
D
Douglas J. Steele
How is that possible? If you've got more than one table involved, you have
no choice but to use a query!
Or do you perhaps have a form with a subform on it?
no choice but to use a query!
Or do you perhaps have a form with a subform on it?
J
Jalal
Yes Sir. It is a form with a subform
Douglas J. Steele said:How is that possible? If you've got more than one table involved, you have
no choice but to use a query!
Or do you perhaps have a form with a subform on it?
A
Allen Browne
Which form is not updatable: the main form or the subform?
Open that one (either the main form, or the subform) in design view.
Open the Properties box.
Tell us what settings you have for the properties, such as:
RecordSource
AllowEdits
Recordset Type
Open that one (either the main form, or the subform) in design view.
Open the Properties box.
Tell us what settings you have for the properties, such as:
RecordSource
AllowEdits
Recordset Type
J
Jalal
The unupdatable form is the subform.
Main form record source; main table, allow edit; yes and recordset type;
Dyanset.
Subform record source; subform table, allow edit; yes and recordset type;
Dynaset
Main form record source; main table, allow edit; yes and recordset type;
Dyanset.
Subform record source; subform table, allow edit; yes and recordset type;
Dynaset
A
Allen Browne
Perhaps the main form's AllowEdits is No. That would block the use of the
subform too.
Otherwise I don't know what's going on.
If the subform is bound directly to a table in this database (not linked
from somewhere else), and the controls are not locked or disabled, and the
form properties are as you say, and there is no Access security implemented,
and the folder where the database exists is writable and you have
permissions for it, and there is no code running in events that would cancel
or disallow the entries, I don't know what to suggest.
subform too.
Otherwise I don't know what's going on.
If the subform is bound directly to a table in this database (not linked
from somewhere else), and the controls are not locked or disabled, and the
form properties are as you say, and there is no Access security implemented,
and the folder where the database exists is writable and you have
permissions for it, and there is no code running in events that would cancel
or disallow the entries, I don't know what to suggest.