I have a database with multiple tables that have related data. I built a main form with a tab control containing 5 tabs. Tabs 1, 2 and 5 all deal with data from the main table.
Tab 3 contains a subform of data Linked using a Link Child Field and a Link Master Field. I recently added record navigation buttons to my forms, removing the built in Access record navigation buttons, in order to control what modules are executed as users navigate and edit records. Tab 4 has two subforms each also linked to two related tables.
As I continued to enhance my forms, a strange thing occurred. When I open the form, the first record has no data on Tab 3 - there are no records in its table that match the link fields. If I try to navigate to record 2 via my next record button (built using the control wizard) all appears normal. Tab 3 gets populated with multiple records that I can navigate through.
The problem occurs when I attempt to navigate to another record on the main form. The data on Tab 3 remains displayed as though all of the records have the same data. So I thought I would add a breakpoint to the form_current event so I could walk through the process and see if I can narrow down the issue. Well, when I restart the process, with record 1, the form_current procedure runs. When I press the Next Record button, it runs again as the form displays the second record. After that, no matter which record navigation button I push, the form does not refresh and the form_current procedure apparently is not running as the breakpoint never fires.
Has anyone any idea what might cause this sort of behavior?