Hello - I would appreciate any insight into a problem I am having with the DLookup function in VBA.

I have an small unbound form (FDatePicker) I plan to use to navigate to specific records on one of my main forms.  FDatePicker has an unbound text box formatted as short date (YYYY-MM-DD in my case).  The text box is named "DatePicker".  The form also has a button where the On Click event has the VBA I am writing.  

I am in the early stages of writing the code so I'm taking it one step at a time. Initially all I want the code to do is look up an ID number (RecordID) from a table in the database (TRecords) where the RecordDate field in the table matches the date selected by DatePicker then display the RecordID in a message box.  I have the intention to do more later but this is step one.  

This is what I wrote:
MsgBox ("RecordID = " & DLookup("[TRecords]!RecordID", "TRecords", "[TRecords]![RecordDate]=" & DatePicker))

But all I ever get back is "RecordID = ".  I never get the RecordID even though I know there would be one for the dates I use to test it.  

As one more test I wrote an extra line to tell me if the DLookup is returning a Null value:
If IsNull(DLookup("[TRecords]!RecordID", "TRecords", "[TRecords]![RecordDate]=" & DatePicker)) Then MsgBox ("It's Null")

I always get the "It's Null" statement

I have verified that the DatePicker and the RecordDate are both formatted as short date, I have also tried wrapping the DatePicker inside the CDate function just in case that DatePicker being a value from a text box had any influence - that didn't help.

What might I be missing here?  Why is what I wrote failing to return the ID intended.

Thank you