Results 1 to 7 of 7
  1. #1
    fedesc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    14

    Buttons doesn't work in Subforms

    Hi guys , i'm kinda newbie in access. i got sort of a dumb question ('cause i know i'm doing something wrong i just don't know what. i looked for answers but couldn't find any.)

    it goes like this :
    i have 2 reports and one form for example
    on the 2 reports i have a command buttons that opens another form that contains the record values

    when i view the report separately the button work.
    when i put it in the main form as a sub forms the buttons suddenly pops up a parameter missing alert box ( i mean the one you can fill the value and hit ok)

    the event of the buttons is onClick macro
    open form


    where [reports]![name of report][name of field]=so on..


    hope i'm clear on my questions and that for you guys it's a kinder garden question!

    sorry about the english . it's not my native!
    hope to hear good news!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    See here for the proper syntax:

    Forms Refer to Form and Subform properties and controls

    In your case, you'd substitute "Reports" for "Forms" and "Report" for "Form".
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    fedesc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    14
    thank u. but i'm not quite sure how to read that , i tried alot of varietions but none of them worked. some of them gave me the pop up and some gave me the form but blank without the specific record :X

    thanks anyway i'll try to figure it out

    meanwhile . is there any thing i can post from my db that will help you help me compile a good working syntx?!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Does this work?

    [reports]![NameOfMainReport].[name of report].[Report].[name of field]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    fedesc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    14
    Nop that doesn't work :X

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Can you post the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    fedesc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    14
    http://www24.zippyshare.com/v/74333639/file.html

    thank you
    what i'm trying to do is to put
    rep_active in frm_navigation

    it's kinda in hebrew but i'm sure you'll get along just fine.

    and in advance thank u verymuch!

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

Similar Threads

  1. App doesn't work with runtime
    By bubba55 in forum Access
    Replies: 0
    Last Post: 09-21-2011, 08:33 AM
  2. Can Grow doesn't work
    By gg80 in forum Reports
    Replies: 6
    Last Post: 05-13-2011, 07:14 PM
  3. Query doesn't work the day after
    By sithis876 in forum Queries
    Replies: 1
    Last Post: 07-13-2010, 07:11 AM
  4. Controls don't work on subforms
    By rscott7706 in forum Forms
    Replies: 8
    Last Post: 03-07-2010, 10:17 PM
  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