Data In Form Cannot Be Edited

I have a form and sub-form. The First (table 1) is a table that contains
Borrower data. The second (table 2) contains their individual loan
information. They can have more than one loan.

I have in table 1 their ID number and a "checkout" check box. This box is
the "eliminating" criteria for accounts that have already been worked.

I have a query that pulls the next borrID (one at a time) using a MIN query.
I called the field BorrID: BorrID so that the form would call it the same
thing. I cannot check the box on the form.

The sub-form is connected by the BorrID and I can edit that data.

I have tried a number of settings: Dynaset, Dynaset (Inconsistant updates),
and Snapshot. I have fiddled with settings in the query properties.

I use a macro to open the form filtering with the query. I have also tried
tying the form directly to the query. Nothing works.

I am not a very good "coder" and have so little experience I suspect I would
break the system to attempt to do something that I am not capable of doing
yet. Any suggestions?

You can't modify records in an aggregate query (which a query using MIN would
be). See here for more about what can make your queries non-updateable:
http://allenbrowne.com/ser-61.html

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________


"Archidrb" wrote:

I have a form and sub-form. The First (table 1) is a table that contains
Borrower data. The second (table 2) contains their individual loan
information. They can have more than one loan.

I have in table 1 their ID number and a "checkout" check box. This box is
the "eliminating" criteria for accounts that have already been worked.

I have a query that pulls the next borrID (one at a time) using a MIN query.
I called the field BorrID: BorrID so that the form would call it the same
thing. I cannot check the box on the form.

The sub-form is connected by the BorrID and I can edit that data.

I have tried a number of settings: Dynaset, Dynaset (Inconsistant updates),
and Snapshot. I have fiddled with settings in the query properties.

I use a macro to open the form filtering with the query. I have also tried
tying the form directly to the query. Nothing works.

I am not a very good "coder" and have so little experience I suspect I would
break the system to attempt to do something that I am not capable of doing
yet. Any suggestions?

Ultimately, I solved this by removing the aggregate functions and in the
query properties asked it to provide the "Top 1 Value" and that worked. I am
getting one resulting BorrID in the main form that is editable, and the
multiple records in the linked sub-form that are also editable.

I had explored some of the query propeties before, but since "1" was not in
the drop-down list provided in "Top Values" I didn't know I could adjust that
to what I wanted.

Thanks for reviewing my question.


"boblarson" wrote:

You can't modify records in an aggregate query (which a query using MIN would
be). See here for more about what can make your queries non-updateable:
http://allenbrowne.com/ser-61.html

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________


"Archidrb" wrote:

I have a form and sub-form. The First (table 1) is a table that contains
Borrower data. The second (table 2) contains their individual loan
information. They can have more than one loan.

I have in table 1 their ID number and a "checkout" check box. This box is
the "eliminating" criteria for accounts that have already been worked.

I have a query that pulls the next borrID (one at a time) using a MIN query.
I called the field BorrID: BorrID so that the form would call it the same
thing. I cannot check the box on the form.

The sub-form is connected by the BorrID and I can edit that data.

I have tried a number of settings: Dynaset, Dynaset (Inconsistant updates),
and Snapshot. I have fiddled with settings in the query properties.

I use a macro to open the form filtering with the query. I have also tried
tying the form directly to the query. Nothing works.

I am not a very good "coder" and have so little experience I suspect I would
break the system to attempt to do something that I am not capable of doing
yet. Any suggestions?