Hi,
I have a problem on my Main form. The main form has 8 pages, but there are three pages where the subform navigation buttons are appearing for no reason, as fields on two of the pages are coming from the main table. I can go to the second record (there is no third for some reason) and nothing happens, but it is really disturbing as users won't understand what is going on. These subforms has been created from a query (only one table). Maybe the problem is coming somewhere there.
The third page has also a query based subform. This includes the ID from the main table and all fields from another table (Relationship is 1-to-many: no referencial integrity ticked, also the table had been added to the database after records were entered to the main table). Two sets of subform navigation button appears. First is obviously for getting from one record to the other, but the second set is very similar to that one that I mentioned above: doesn't seem to have any function really, even if I have got plenty of records entered in the subform.
Below all these I have the Main navigation button, which is fine. Working well and getting from the first ID to the next one (out of 500).
I don't know how clear I was. Sorry for the lot of detail, but I thought I close out all misleading options.
Many thanks for your help.
I have a problem on my Main form. The main form has 8 pages, but there are three pages where the subform navigation buttons are appearing for no reason, as fields on two of the pages are coming from the main table. I can go to the second record (there is no third for some reason) and nothing happens, but it is really disturbing as users won't understand what is going on. These subforms has been created from a query (only one table). Maybe the problem is coming somewhere there.
The third page has also a query based subform. This includes the ID from the main table and all fields from another table (Relationship is 1-to-many: no referencial integrity ticked, also the table had been added to the database after records were entered to the main table). Two sets of subform navigation button appears. First is obviously for getting from one record to the other, but the second set is very similar to that one that I mentioned above: doesn't seem to have any function really, even if I have got plenty of records entered in the subform.
Below all these I have the Main navigation button, which is fine. Working well and getting from the first ID to the next one (out of 500).
I don't know how clear I was. Sorry for the lot of detail, but I thought I close out all misleading options.
Many thanks for your help.