Results 1 to 2 of 2
  1. 05-12-2011, 01:45 PM #1
    kpetrides
    kpetrides is offline Novice
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    1

    How to reference a control on a subform in a query

    I used to use this expression to reference a subform control value in a query but it is not working any longer: =[forms]![mainform]![subform].[control]

    Can someone help??
    Reply With Quote Reply With Quote
  2. 05-12-2011, 02:25 PM #2
    ketbdnetbp
    ketbdnetbp is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Midwest
    Posts
    254
    Try...

    [Forms]![MainFormName]![SubformName].Form![ControlName]
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Control Reference on a Form
    By gmitchell@exbrief.com in forum Forms
    Replies: 5
    Last Post: 01-24-2011, 12:31 PM
  2. form/subform reference problem
    By dbertanjoli in forum Forms
    Replies: 1
    Last Post: 01-10-2011, 03:31 PM
  3. Variable within form control reference
    By Tyork in forum Programming
    Replies: 2
    Last Post: 10-13-2010, 09:55 AM
  4. Creating a reference to the subform.
    By evander in forum Forms
    Replies: 2
    Last Post: 05-26-2010, 09:39 AM
  5. Can't reference control in subform
    By evanscamman in forum Forms
    Replies: 0
    Last Post: 12-25-2007, 06:47 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums