using a date as criteria for DLookup

Topic

New Reply

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

Reply | Quote

Replies

Try this:

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

Reply | Quote

thanx…will give it a try

Reply | Quote

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.

Reply | Quote