Results 1 to 6 of 6

Form within a form

  1. #1
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    56

    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 Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    595
    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
    10,914
    You may find this link useful: http://access.mvps.org/access/forms/frm0031.htm
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  4. #4
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    56
    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
    10,914
    You may want to use [Forms]![FormName]![SubformName].FORM![Text1]
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  6. #6
    jaykappy is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2009
    Posts
    56
    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, 05:58 AM
  2. Replies: 1
    Last Post: 08-19-2011, 01:53 PM
  3. Replies: 9
    Last Post: 02-15-2011, 01:05 PM
  4. Replies: 1
    Last Post: 11-07-2010, 09:04 AM
  5. Replies: 9
    Last Post: 03-24-2009, 08: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
  •  
Tech Forums: Microsoft Office Forums