Results 1 to 5 of 5
  1. #1
    FTAUSS is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    8

    First question

    I am in a new position and maintainging some preexisting code. The code is not how I would have done it but I am stuck with what I got.



    Basic problem:

    We have a form. On the form are some controls and a tab group. The tab group has 5 tabs each of which displays it's own form.

    I added one of these tab/form combinations. On that form I placed 3 option group controls with 5, 3 and 2 options in each. If I run the form by itself the option groups work. The selecter moves from button to button and in tracing we go through the On-Click Subs just fine. But when run as part of the larger app the option buttons within the option groups don't work. Even temporary option buttons I placed on the form don't work, it is clear that despite there being On Click set for each, noting happens. The On Click for the Option Group (but not on a button?) will take me to the option group On Click sub but it has a value of zero.

    I've been over it pretty thoroughly, the controls are enabled and unlocked, it just seems as if the controls can't find the On click Subs.

    There is a set sequence the users follow wherein at one point the fields are editable and at other times are locked. However I have not put any of that code in this module yet. It appears to be a visibility problem, meaning the module for the form isn't visible to the form being displayed.

    I'm sure the answer is something simple I am overlooking but HELP! PLEASE!

    Frank

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Can you provide project for analysis? Copy, remove confidential data, run Compact & Repair, zip if large, attach to post. Attachment Manager is below the Advanced post editor.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    FTAUSS is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    8
    Quote Originally Posted by June7 View Post
    Can you provide project for analysis? Copy, remove confidential data, run Compact & Repair, zip if large, attach to post. Attachment Manager is below the Advanced post editor.



    Not really. What s on the screens is propietary, it involves methods ad practices. And since this is a GSE , well I think you should understand.

    In a nutshell the subform is loaded and control appears to return to the master form with the tabs. At least that is where the code stops.

    private sub "On Tab change"
    do something
    display the subform
    do something else

    end sub

    I had this problem a year ago, but I found a way to work around and didn't focus on it. The form is loaded, but then all the controls don't know where thier code is and won't respond to clicks. The tabs sit on the master form has control and that form still knows where it's procedure code is and responds to clicks.

    Does the sub form need an activate or setfocus, I would have thought clicking on it was enough,

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Sorry, can't help if I can't analyze project.

    Does debugging (set breakpoint) confirm that code does not run at button click?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

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