If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Data In Form Cannot Be Edited
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? |
#3
|
|||
|
|||
Data In Form Cannot Be Edited
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? |
Thread Tools | |
Display Modes | |
|
|