I have two tables.
I have created a form and a second form within the first as a subform.
I relate the first form to the first table and the second form(subform) to the 2nd table.
The two tables are not related since one is not subordinate to the other.
At this point I can select a field in the 2nd form, but not enter data.
Am I trying to do something I shouldn’t or what am I doing wrong that prevents me from entering data in the second form. Thanks.
Not from your description. One common example for form/subform where datasources are independent is a filter-table and a subform based on a query.
.
The main reason for tables, where you can not edit data is a missing primary key…
I checked and the primary keys are defined.
What I discovered (another symptom) was that when I go to the Data tab of any of the fields in the form, that the Data field… control drop down only shows the previously selected field and the other fields in the table are not listed as well. I think somehow the fields have gotten disconnected from the form, though when I click on a field in the form view, it selects the associated field in the form navigator list.
This sounds like the table content of the Form or subForm data properties has not been set. From the right click menu of any control in the form/subform select - Form Properties / Data tab
- Content type = “Table”
- Content = “tableName”
- Do not link master / slave fields.
- Allow additions, modifications, and deletions
While working in form design mode, the most important tool is the form navigator (menu:Form>Form Navigator).
It is a tree view with “Forms” as root node, independent data forms below the “Forms” and arbitrary hierarchies of dependent sub-forms below the form.
The form navigator shows each (sub-)form’s form controls and sub-forms. It does not explicitly show the column controls of a table control.
In the form navigator, you can drag misplaced elements between forms.
Every sub-form (not the main forms below the root “Forms”) has master and slave fields where the slave fields can be a list of parameter names or column names and the master fields are the parent forms in corresponding order to the slave fields.