Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    49

    Unanswered: DLookup assistance

    Hello,
    I am trying to do the following

    txtmorning.ControlSource = DLookup("morning", "shiftsummary", "sdate = [txtlookup]")

    however it is incorrect because txtlookup is 14/14/2005 (a date) therefore I need something like txtmorning.ControlSource = DLookup("morning", "shiftsummary", "sdate = #'" & txtlookup & "'#") but this isn't working either...I tried a couple other things...any suggestions?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Your syntax is still off. Here's a good reference:

    http://www.mvps.org/access/general/gen0018.htm
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •