Results 1 to 2 of 2
  1. #1
    caddcop is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Location
    Upper Marlboro, Maryland, USA
    Posts
    57

    Form Stops Updating Subforms

    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?

  2. #2
    caddcop is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Location
    Upper Marlboro, Maryland, USA
    Posts
    57
    I determined that the issue appears to be that I was attempting to set the Selected property of my listboxes without first using the SetFocus method. By adding this step, all of my issues with the dialog boxes were fixed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form and 3 subforms
    By Mitka in forum Forms
    Replies: 2
    Last Post: 01-15-2011, 02:43 PM
  2. Replies: 2
    Last Post: 03-14-2010, 08:21 AM
  3. Having - Like stops working
    By tdalber in forum Queries
    Replies: 0
    Last Post: 02-03-2009, 04:30 PM
  4. Replies: 0
    Last Post: 12-16-2008, 07:49 AM
  5. Replies: 2
    Last Post: 04-11-2006, 08:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums