Results 1 to 3 of 3
  1. #1
    Arsalan is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    11

    Query not show result

    SELECT [tb1].[FATAL]+[tbl2].[LWDC] AS Expr1


    FROM tbl_Oall_hse_perfo;

    When i run this query individually then it gave me result perfectly but when i want its result in textbox on form it's not working. I add this query in Property sheet(Control Source) property expression builder.

    Help!!!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    You can't use SQL in a textbox like that. You can make it the row source of a combo or use a DLookup in the textbox.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Arsalan is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    11
    thanks a lot.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-31-2012, 12:14 PM
  2. show a query result in a text box
    By mikael in forum Access
    Replies: 2
    Last Post: 09-13-2012, 02:17 AM
  3. Replies: 2
    Last Post: 05-30-2012, 07:53 AM
  4. Replies: 1
    Last Post: 09-28-2011, 09:48 PM
  5. Replies: 1
    Last Post: 07-12-2009, 05:09 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