Forms does not allow to modify data

[Guest]

I will like to create a form that has data already filtered by the last date
(of a date field called [fecha_realizado]). I will like to modify a check
box field in this form. When I am using a query in the control source of the
form and in the design view of the query I am summarizing data with the total
option (selecting Group By and Last) the forms does not allow to modify data.
In the properties of the form the Allow filter, Allow edit, Allow deletion,
Allow addition are defined as Yes.

Normally I made a main form with a textbox and inside this form I add a
subform, then define the field that should be filtered in the Link Master
Fields and Link Childs Fields. But in this case I will like to filter by the
last of [fecha_realizado], and this date is different for each record.

Example without filter:

fecha_realizado codigo_mantenimiento numero_propiedad activar_OT
11/5/2006 INS(30) MEZC-10,000 â­
10/1/2006 INS(30) MEZC-10,000 â­
7/15/2006 INS(30) MEZC-10,000 â­
9/1/2006 FIL-POL(180) PREN-001 â­

Example using a query to filter data:

fecha_realizado codigo_mantenimiento numero_propiedad activar_OT
11/5/2006 INS(30) MEZC-10,000 â­
9/1/2006 FIL-POL(180) PREN-001 â­

I know how to define the query, my problem is that I can’t modify data in
the form.

 

[Van T. Dinh]

The data set returned by a Total Query (i.e. Query with a Group By clause)
is not updatable and therefore data shown on the Form is not updatable.

If you look at it this way: the Table has 5 records and your Form shows 2
summarised rows. If you modify one of the summarised row, Access got no way
of knowing which Record (in the Table) to be updated.

 

[aaron.kempf]

well.. if you used Access Data Projects; you would have 2 ways to deal
with this:

A) uniquetable property
b) instead of triggers

MDB is for babies

The data set returned by a Total Query (i.e. Query with a Group By clause)
is not updatable and therefore data shown on the Form is not updatable.

If you look at it this way: the Table has 5 records and your Form shows 2
summarised rows. If you modify one of the summarised row, Access got no way
of knowing which Record (in the Table) to be updated.

--
HTH
Van T. Dinh
MVP (Access)

I will like to create a form that has data already filtered by the last
date
(of a date field called [fecha_realizado]). I will like to modify a check
box field in this form. When I am using a query in the control source of
the
form and in the design view of the query I am summarizing data with the
total
option (selecting Group By and Last) the forms does not allow to modify
data.
In the properties of the form the Allow filter, Allow edit, Allow
deletion,
Allow addition are defined as Yes.

Normally I made a main form with a textbox and inside this form I add a
subform, then define the field that should be filtered in the Link Master
Fields and Link Childs Fields. But in this case I will like to filter by
the
last of [fecha_realizado], and this date is different for each record.

Example without filter:

fecha_realizado codigo_mantenimiento numero_propiedad activar_OT
11/5/2006 INS(30) MEZC-10,000 ?
10/1/2006 INS(30) MEZC-10,000 ?
7/15/2006 INS(30) MEZC-10,000 ?
9/1/2006 FIL-POL(180) PREN-001 ?

Example using a query to filter data:

fecha_realizado codigo_mantenimiento numero_propiedad activar_OT
11/5/2006 INS(30) MEZC-10,000 ?
9/1/2006 FIL-POL(180) PREN-001 ?

I know how to define the query, my problem is that I can't modify data in
the form.