Results 1 to 4 of 4
  1. #1
    Mike B
    Guest

    using a date as criteria for DLookup

    Hi All....i am trying to get a text box to fill using the DLookup function....this is what I have for the control source...
    =DLookUp("[tblConversionFactors]![ConversionFactor]","tblConversionFactors","[ConversionDate] =" & [Forms]![frmTransactionsEntryEdit]![txtTransactionDate])

    it returns a NULL even though I know there is a factor for the txtTransactionDate on the form....any ideas TIA

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using a date as criteria for DLookup

    Try this:

    =DLookUp("[tblConversionFactors]![ConversionFactor]","tblConversionFactors","[ConversionDate] =#" & [Forms]![frmTransactionsEntryEdit]![txtTransactionDate] & "#")

  3. #3
    Mike B
    Guest

    Re: using a date as criteria for DLookup

    thanx...will give it a try

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using a date as criteria for DLookup

    You also might think about changing the [txtTransactionDate]field to a date field in your table design, that is if this date field is a txt field.

Posting Permissions

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