Facing Problem in Dlookup() function for Datefield only

[NasonsAssociates]

I have create a customer data table and Dlookup that values in a form through Dlookup function all fields are copied and lookup except date. Only date field of the customer table is not working and all others fields are working properly I am using access 2007 version and widows version is 2010 and 2011. Kindly guide me about that how to input value from dlookup function in date field. Please find my coding are as below:

Private Sub Contract_Start__Date_KeyPress(KeyAscii As Integer)


Contract_Start_Date = DLookup("Contract_Start_Date", "Customer_Data", "Customer_ID=" & Customer_ID)
End Sub


Kindly look into this matter and guide me about the statement As early as possible
Thanking You,
Yours Faithfully
For Nasons Associates

[orange]

Why the KeyPress event?
See the similar threads at bottom of this page to see other responses that may apply.

[Welshgasman]

As early as possible???

It will be looked at if someone decides to take it on. Unlikely to be me with that attitude.

[Micron]

What is the data type of Customer_ID. If it's text data type you have to delimit it.

"Customer_ID='" & Customer_ID & "'")

[CJ_London]

Only date field of the customer table is not working

what does this mean? you get nothing? a wrong result? an error message?

provide examples of the data and datatypes of what is in the customer data table and what your dlookup is returning

[June7]

Why are you even using DLookup to populate a form? Why don't you just use CustomerID to apply filter to a bound form?

[NasonsAssociates]

you get nothing?

provide examples of the data and datatypes: The Data is only Date in DD/MMMM/YY format
of what is in the customer data table: The Consumer Detail Information is available in Customer Tata Table i.e. Name, Address Phone, Contract Date and Contract End Date etc.

[NasonsAssociates]

The data type of Customer_ID is Auto Number

[NasonsAssociates]

Why the KeyPress event?
Because when I press the Tab Key or Enter Key it will retrieve the date value from "Customer Data" Table

[NasonsAssociates]

Because when I press the Tab Key or Enter Key it will retrieve the date value from "Customer Data" Table

[NasonsAssociates]

The Data Type is Auto Number

[Minty]

Move it to the after update event of the customer ID.