Recent content by kiko11

WHERE IS THE CODE ???

Yes I need to check for duplicates ( Id and Date ) if they duplicates the msgbox show

u r right . i want to show msgbox if the id and date is duplucated . Thanks

I have 2 fealds ( Id and date ) they are primery keys in the table , I want to prevent duplacte id to the same date . ( MSGBOX after update the date )

Thank u Sccotgem 4 ur code , and thanks 4 Rich . it is right in beforeupdate and i modifi the code to that : If Me!inv_date < DLookup("[B_Date]", "tbl_Year") Or Me!inv_date > DLookup("[E_Date]", "tbl_Year") Then MsgBox "Invoice date outside of range", vbOKOnly DoCmd.CancelEvent SendKeys...

u mean one row ? or what u mean ?

First Thank u ScottGem for replay me . u r right , u understand what i want exact. my tblyear contan 2 fead not 1 , The 1st B_date , 2nd E_date Thanks again

Is my Quest not clear ???

Hello all Ihave tblyear contain ( B_date and E_date ) in anoter form have feald ( invdate ) i wnat ( Invdate) is between B_date and E_date of the tblyear. Thank u