Results 1 to 5 of 5
  1. #1
    joemills62 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    21

    Sub Forms Help

    I have a main form.
    On the form i have a group selection box
    example
    address = 1
    telephone details = 2
    etc
    etc

    I have a number of sub forms for example address details
    when the group selection box if checked then the addressd details appear


    i have got this to work ok.
    but when i selct another check box then the form example telephone appears ok, but in table form, not as designed as a sub form

    also how do i have multiple if staments
    example on my group selction box i i have

    If frame90 = 1
    then subform address.visable = true
    else subform address.visable=falsoe
    endif

    i also want to add on
    if frame90 = 2
    then subform_telephone.visable=true
    else subform_telephone.visable=false
    endif
    but this does not work

  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
    Why doesn't it work - error message, wrong results, nothing happens?
    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
    joemills62 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    21
    The form shows only in table view, not in the designed view

    i have fixed the the option box to display the forms

  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
    Would need to analyze the project if you want to provide it.
    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
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    The subform would need to have its default view set to either single view or continuous view instead of datasheet.

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

Similar Threads

  1. Multiple forms or embedded sub-forms
    By Juicejam in forum Forms
    Replies: 2
    Last Post: 08-23-2011, 07:31 AM
  2. Replies: 1
    Last Post: 01-04-2011, 05:04 AM
  3. Search forms and sub forms
    By FadingAPE in forum Forms
    Replies: 1
    Last Post: 12-15-2010, 01:59 PM
  4. Replies: 4
    Last Post: 04-01-2009, 08:49 PM

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