Results 1 to 2 of 2
  1. #1
    donnan33 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    52

    Form problem

    I have attached a copy of what I am using.



    When I open my form "frmworkordernumber", it works like I want. I click project number, client number pops in and it shows only work orders under that project in list. this is what i want it to do.

    when I move it as a subform in the main form I keep getting and error. I think something is wrong with the naming of the form????? if you open the frm employeename (which is main form) I get an error.

    If I go to the workorderid control in desgin view, and go to query builder, there is where i referenced the form. Because it is in the main form now do I need to change the name somehow? It works as in when form is stand alone but not when put in main form as subform......

    can anyone help?
    thanks

  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,641
    I haven't looked at your db, but yes, the syntax to refer to the form changes when it's a subform:

    Forms Refer to Form and Subform properties and controls
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Sub Form problem
    By sk88 in forum Access
    Replies: 2
    Last Post: 01-05-2012, 02:48 PM
  2. Form problem
    By DPG in forum Forms
    Replies: 12
    Last Post: 09-17-2010, 09:05 AM
  3. Form problem
    By mc24 in forum Forms
    Replies: 3
    Last Post: 08-04-2010, 06:39 AM
  4. Form Name Problem
    By jgelpi16 in forum Programming
    Replies: 4
    Last Post: 07-22-2010, 12:56 PM
  5. Replies: 2
    Last Post: 06-14-2010, 03:25 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