I have a single record subform (not continuous) based on a table with a one to one relationship with the main form table.
I have removed record navigation and set the subforms enter control to cycle the one record
This means I can prevent users trying to move to a new record on the subform. Except they can use the page up page down keys on the keyboard which moves to a new record.
What I do not understand is if two tables, form and subform, have a one to one relationship, why does access even allow moving to a new record on a subform with such a link and how do I prevent it.
In a query using main and subform tables where the subform has two records the query would duplicate the main form details an double the number of items. That's a disaster.