Results 1 to 5 of 5
  1. #1
    Yatzek is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    5

    Problem with query result in text field on the form

    Hello,When try to connect a query as a source of text box control on the form, in the text field appears #Name?.Here is the source control assignment := [q_Date_Of_Last_Event]! [MaksimumOfData].
    The query when acting
    independently returns one date of the last event and is working properly. There are no typos because Im using the suggested fields from wizard. What's wrong?


    Help, how to assign it to work

  2. #2
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    You could use something like this

    =DLookUp("MaksimumOfData","[q_Date_Of_Last_Event]","Criteria='" & Forms!YourForm!YourCriteriaField & "'")

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Dlookup("[maksimumofdata]", "[q_date_of_last_event]", "condition if query returns more than one row"


    Sent from my iPhone using Tapatalk

  4. #4
    Yatzek is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    5
    Thank You! It works!
    Dlookup is the solution then. Quite logical, as source for the form is a different table.

  5. #5
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    You're welcome

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

Similar Threads

  1. Replies: 3
    Last Post: 11-12-2014, 09:13 AM
  2. Replies: 1
    Last Post: 07-03-2014, 08:27 PM
  3. Replies: 20
    Last Post: 03-30-2014, 12:18 PM
  4. Replies: 1
    Last Post: 01-06-2013, 01:47 PM
  5. Replies: 12
    Last Post: 06-25-2012, 01:42 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