insert code

[krzysiekk]

Exacly I using combo box,

vection table content:
vectiontrailertrailer_datestatusrequired_dateLANGDONS1
U31/03/2011LANGDONS2
U31/03/2011LANGDONS1
U31/03/2011LANGDONS2
U31/03/2011LANGDONS1
U04/01/2011LANGDONS2
U31/03/2011LANGDONS1
U31/03/2011

Maybe your machine is different language or location option because in form showing 01/04/2011 but addes in table 04/01/2011

And still creating duplicates

 

[krzysiekk]

Ok I found:

Before:
If DCount("*", "vection", "trailer='" & Me.trailer & "' AND trailer_date=#" & Me.req_date & "#") = 0 Then

I changed:
If DCount("*", "vection", "trailer='" & Me.trailer & "' AND required_date=#" & Me.req_date & "#") = 0 Then

Many thanks working now

 

[jzwp22]

Glad you got it working. By the way, SQL (not Access) always interprets dates as mm/dd/yyyy