Results 1 to 6 of 6
  1. #1
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    59

    Form within a form

    I have a form that has many little forms in it....Each form is referecing a query. This works fine as each form in that form filters itself by referencing a textbox

    Like [Forms]![frm_V4_Calendar]![Text1]

    But what I want to do is place this form within another larger form. I get errors when trying to run it....Its looking for the Parameter Value "Forms!frm_V4_Calendar!Text1"

    this is specified in the query for each form as such I get an error for every form in that form...Can I string the two forms together in the query?

    Like FormMain.SubForm.text1 ?????

    How can I modify this to make it work....THANKS in advance...I hope that makes sense????

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Yes, the text is now on another level and each level has to be referenced - Forms!FormName!SubformName!Text1

    Why are you using Like? That is a slower process than just plain equals. Unless there are wildcard characters included.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You may find this link useful: http://access.mvps.org/access/forms/frm0031.htm

  4. #4
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    59
    Thanks fro yoru input....appreciated...so something like this

    [Forms]![FormName]![SubformName]![Text1]

    I dodnt know that Like was a slower process...will change to = without a doubt....

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You may want to use [Forms]![FormName]![SubformName].FORM![Text1]

  6. #6
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    59
    THanks all....my last post worked great....all set...Thanks again....Cheers

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

Similar Threads

  1. Replies: 1
    Last Post: 11-21-2011, 07:58 AM
  2. Replies: 1
    Last Post: 08-19-2011, 02:53 PM
  3. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  4. Replies: 1
    Last Post: 11-07-2010, 11:04 AM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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