i am new in VBA and Access. i am trying to develop application using forum helps. i am fetching data from MS access table in excel using IPR_ID field (multiple records for one IPR_ID (Sr No field is set as Primary Key in access Database.)) and displaying it in Userform with Active cell value which works fine but at the same time i would like to update access database AD_State field for same IPR_ID with LOCKED status to lock records for others to View or Edit fetched records. update Active row excell cells from Userform and from excel to Access Database table with AD_State UNLOCKED Below is the Find Records click button code in Find_Rec userform
Code:
|