Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dlook? (Access 2000)

    Can anyone give me advice on how to create a control source using the function Dlook? The access help file just confused me and it didnt work out?

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dlook? (Access 2000)

    Hi

    If you send a little more info on what you're trying to us as the DLookup we could probably advise better, but here's an example of one of my DLookup's:-

    =DLookUp("DateOfReferral","tblDetails","EstimateNo = " & Forms!frmDetails!EstimateNo & " and Supp = " & Forms!frmDetails!supp)

    This looks up the"DateOfReferral" in"tblDetails" where "EstimateNo" & "Supp from "tblDetails" matches "Forms!frmDetails!EstimateNo" & "Forms!frmDetails!supp"

Posting Permissions

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