Hi Guys
In the attached sample Db there are following tables
1) tblCargoMaster
2) tblClearanceDetails and
3) tblLoadingAndDelivary
in the frmCargoSearch when double clicked MAWBNo field frmCargoMaster opens. In that form I have provided tab control in it there are two tabs clearance, Loadding and delivery.
Now what I want do is
1) clearance date should not be earlier than flight date or earlier than loading date.
2) loading date should not be earlier than flight date OR clearance date.
if inappropriate date is entered msgbox should appear.
foxtet
In the attached sample Db there are following tables
1) tblCargoMaster
2) tblClearanceDetails and
3) tblLoadingAndDelivary
in the frmCargoSearch when double clicked MAWBNo field frmCargoMaster opens. In that form I have provided tab control in it there are two tabs clearance, Loadding and delivery.
Now what I want do is
1) clearance date should not be earlier than flight date or earlier than loading date.
2) loading date should not be earlier than flight date OR clearance date.
if inappropriate date is entered msgbox should appear.
foxtet