I have an Access database with a Navigation Form. The Navigation Form has 14 ‘tabs’, each of which opens a sub-form. Each sub-form retrieves data from its own table. The tables are related by a single field ([ID]); the relationships are defined in ‘Relationships’ and each table’s [ID] field is linked (one-to-one) to the FIRST tabbed table/form’s ID field.
What I want is quite simple: The user opens the Navigation Form (which opens the ‘Home’ sub-form by default). (S)he then navigates to the required record. Then, when clicking on any tab, the sub-form showing the RELATED record (ie; it has the SAME [ID] number) should appear for editing/reading.
What actually happens is that when a sub-form is chosen (from the tabs) the FIRST record appears. I cannot understand Microsoftese and so Access Help is of little … well, help. Can anyone help with what (surely) has to be a simple answer?
