Results 1 to 2 of 2
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    one form two sources - invalid control source msg

    i have a Form with a data source for most the fields on the form. But I need to bring in values from another table and I am having trouble getting the right syntax.
    This is what I have now:
    Employer Name «Expr» [QryCAPSLlink]![Employer Name]

    The query is just pulling one record.
    <<Code>>
    SELECT Tbl403bCAPSLlink.[Remitter/ Plan Number], Tbl403bCAPSLlink.[Employer Name]
    FROM Tbl403bCAPSLlink
    WHERE (((Tbl403bCAPSLlink.[Remitter/ Plan Number])="1291"));
    <<Code>>



    Attached are screen prints. Any help will be greatly appreciated.

    Thank you

    Russ

  2. #2
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    solved

    =DLookup("[Employer Name]", "Tbl403bCAPSLlink", "[Remitter/ Plan Number]='1291'")

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

Similar Threads

  1. Replies: 1
    Last Post: 04-29-2010, 05:15 PM
  2. Replies: 2
    Last Post: 07-30-2009, 08:02 AM
  3. Control source and calculated values
    By meistersteff in forum Forms
    Replies: 0
    Last Post: 11-23-2007, 07:04 PM
  4. Replies: 0
    Last Post: 11-17-2006, 09:38 AM
  5. Changing the record source in a form
    By lmichaud in forum Forms
    Replies: 1
    Last Post: 07-09-2006, 09:20 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