I have run into a situation in my Access 2010 database that I don't understand. I have a form with many other forms on a Tab Control. The original issue was that the subtotals on a continuous form stopped loading. I have reworked the form and now have the subtotals loading on Form_Current using a DOA.Recordset. So, now the form looks beautiful but the data has become read-only.
Background: This database is an Access front end linked to Oracle and Access back end tables. The Access tables are newer tables that we have not yet switched to Oracle.
The form I am working on has 6 tabs on the tab control.
The first tab has 2 forms residing on it. Both of these forms get their data exclusively from Oracle tables. The first form is the continuous form that I referred to above. It is loading the details from a query and the headers and footers (totals) from the DAO.Recordset. The text box on this form is loading as read only. The second form is a single form that has both check boxes and text boxes. The check boxes on this form work but the text boxes are read only. The properties on both forms are set to Enabled=Yes, Locked=No. When I open the form separate from the tab control I am able to update all fields.
The second tab has 1 form and indicators (rich text boxes that load red, yellow, green based on the status of cost, schedule, scope, and funding). The indicators load through functions and the form gets its data exclusively from Oracle. I am getting the same results with the check boxes, and the combo boxes updating but the text boxes being read-only. The properties are set to Enabled=Yes, Locked=No. When I open the form separate from the tab control I am able to update all fields.
The third tab as 1 form that gets its data exclusively from Oracle. This form is all check boxes and combo boxes and it is update-able.
The fourth tab has 1 form that is pulling data from an Access table. The data is maintained elsewhere and is information only on this form. This is read only by design and is loading fine.
The fifth tab has 2 forms that are pulling data from an Access table. These forms are also read only by design and loading as expected.
The sixth tab has 1 form that is pulling 1 field from Oracle and the rest of the fields from Access. This form has text boxes and a few commands. This form loads correctly and the data in both the Oracle and Access fields can be updated.
If the user goes into the sixth tab and then back to the first or second tab the text fields that were read-only are now update-able. I moved the sixth tab to be first and this holds true. The user does not need to make any changes on the sixth tab; just going into it resolves the read-only issue. The problem with moving the sixth tab is the users need to update the sixth tab much less often than the first tab and it is not logical to go into the sixth tab first.
As I was typing this all up to get your input on what is happening and why, I came to the hypothesis that it has something to do with the mixture of the Access and Oracle tables as the data source for the forms. Have you run into this issue? Can you explain what is happening? Is there a better way to solve this?
Thank you for taking the time to read and respond to my issue.