Hi Everyone,
I have following field on my form & sub form.
FIELDS & OBJECTS
Sub form Name = frmObjectFORMS_subform
Main form =frmUsersFORM_Permissions
Save Changes button = BtnSaveChanges
Combo Box = cboUsername
OBJECTIVE
tblObjectFORMS is a list of forms that i have in Database and i am doing permission to each user for each form in my subform which is from tblObjectFORMS is having fields Yes/no ticks for [ReadOnly],[Edit],[Print],[FullAccess].[Addnew],[Delete].
So if i have change any user permission which is check or unchecked the tick box and after i press the save changes button it should give me the message with YES and NO asking "Do you want to save changes to above User Permissions ?" if i press yes than it should save and close the form, but if i press no than whatever my selection was made for that user or that session should be unchecked so that mean no changes should be saved.
I might be little complicated at explaining but its necessary to tell whole story to understand clearly.
Any help will be appreciated.
I have following field on my form & sub form.
FIELDS & OBJECTS
Sub form Name = frmObjectFORMS_subform
Main form =frmUsersFORM_Permissions
Save Changes button = BtnSaveChanges
Combo Box = cboUsername
OBJECTIVE
tblObjectFORMS is a list of forms that i have in Database and i am doing permission to each user for each form in my subform which is from tblObjectFORMS is having fields Yes/no ticks for [ReadOnly],[Edit],[Print],[FullAccess].[Addnew],[Delete].
So if i have change any user permission which is check or unchecked the tick box and after i press the save changes button it should give me the message with YES and NO asking "Do you want to save changes to above User Permissions ?" if i press yes than it should save and close the form, but if i press no than whatever my selection was made for that user or that session should be unchecked so that mean no changes should be saved.
I might be little complicated at explaining but its necessary to tell whole story to understand clearly.
Any help will be appreciated.
