Recent content by Talatraja

Thank you its good idea ,but here is one way i tried to get required result Private Sub CONTRACT_Number_AfterUpdate() Me.Submittal_No.SetFocus If Me.CONTRACT_Number.Value = DLookup("contract_number", "submittal_detail", "contract_number = '" & Me.CONTRACT_Number.Value & "' And submittal_type =...

yes i understand but the problem is this form is related to front end user and i cant show the previous submittal record on user form ,user should only enter the submittal information , i just need that contractor should submit the sample submittal only before package submittal after complete...

sorry i didn't explain you exact, in short if a project is already received as "package" after that no new submittal should be received as "sample" the sample submittal only eligible before submitting package. thanks

here i attached my files ,in this file one record related to contract 11121173 is troubling or wrong because it received the package first and after that received the sample , but another record related to contract 31131131 is all ok and sequence is fine , i attached image for form where...

actually the receiving user on multiple location and we using it with shard files i shared front end to receiving user and back end to my database ,an

Thanks you for your reply , but i cant reach, here i attached my files ,in this file one record related to contract 11121173 is troubling or wrong because it received the package first and after that received the sample , but another record related to contract 31131131 is all ok and sequence...

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...