hi i am new in access and vba sorry if i ask some thing wrong or if i not explained my question due to my language issue, i making database for project documents our propose is that we received a as built drawings for final projects ,we received sample submittal submittal only at starting project then its approved or reject after that contractor submit the complete package submittal, now the problem is that some contractor submit the sample submittal after the package we want to restrict contractor to submit the sample after package submittal ,as we need only sample first, i have one table is projects detail with primaty key project number and other one is for submittal datils with submittal number as primary key and project number as fo key, submittal typ ,submittal date, replly date and status, user enter data through form with same field including combo box of submittal type with sample and package,
just need to prevent entering the sample submittal after package submittal, thanks
just need to prevent entering the sample submittal after package submittal, thanks