Results 1 to 3 of 3
  1. #1
    Jacqoli4's Avatar
    Jacqoli4 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2015
    Location
    Newcastle, KZN
    Posts
    7

    DLookUp in control source of text box only returns value when clicked on

    Good Day,



    I have 3 text boxes on a form each of which gets their values from different queries using DLookup this is functional but only when I click on the text box its self, I have tried using the "On load" & "On current" to requery the textbox (Text38 as control name) but no luck,, another strange thing i've noticed, when I have the form open in access and i click on my taskbar, thus switching windows from access to the desktop but keeping access in view, all text boxes are calculated immediately.

    Please help

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The text boxes should get their data from the form query. Then assign the box to the field. Fastest.

    if you can't, then put the DLOOKUP in the ON CURRENT event. So if you change records, the data will change.
    =Dlookup(fld,qry,where)

  3. #3
    Jacqoli4's Avatar
    Jacqoli4 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2015
    Location
    Newcastle, KZN
    Posts
    7
    Chose 2nd option work great, Thank you!

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

Similar Threads

  1. Replies: 15
    Last Post: 12-31-2013, 05:16 PM
  2. Dlookup as control source on continuous form.
    By Ramun_Flame in forum Programming
    Replies: 4
    Last Post: 10-24-2012, 10:26 AM
  3. DLookup in Control Source
    By bgephart in forum Forms
    Replies: 2
    Last Post: 08-28-2012, 02:06 PM
  4. DLookup() for Text Box Control Source
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 02-06-2012, 02:21 PM
  5. Dlookup as Control Source
    By alsoto in forum Forms
    Replies: 1
    Last Post: 08-28-2011, 07:05 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