ive been working on an database and i want to add a record so i am using
DoCmd.RunSQL (INSERT INTO Booking " & "(MemberID, CourtID) " & " VALUES (11, 1);)
but when i add the next fields the date and time and i get a 3134 error
DoCmd.RunSQL ("INSERT INTO Booking " & "(MemberID, CourtID, Date, Time) " & " VALUES (11, 1, #25/06/06#, 10:00);")
ive changing the # and ' doing various combinations of the two.
ive searched the internet and this forum for about 2 hours but i cant get it to work.