I am using a recordset to enter a record from a form into an Access database. I am thinking somehow I am going to have to incorporate the # signs on either side of the date from the form to get it to go into access. Does anyone have an example of how to do this?

Thanks in Advance,
Kevin

Here is an example of how I did something similar. It places the current date into the recordset.
-----
        ' Create new record then fill it in
     objRSOrder.AddNew
     ' tag this order
     objRSOrder("CustID") = objRSCustomer("CustID")
     objRSOrder("Date") = Date
     objRSOrder("SaleAmount") = CCur(Session("curSubTotal"))
             'Commit the new order to the database
     objRSOrder.Update
-----
Hope this helps.
Arden

If I understood...

you have to transform the date variable as follows:
d="#" & d & "#"
, and that value you can use in INSERT statement as:
INSERT INTO tbl (id,date) VALUES(" & id & "," & d & ")"

HTH.

Reg,
NotNowJohn

...but the Soon is eclipsed by the Moon

Thanks all, I got it!:D

Kevin