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