Hi, I am working Access 2007. I am using subforms as datasheet view. I am embeding this subform to another main form. In main form this subform displays like Gridview, behind this i have some text box control on the main form. when i am selecting the records from the subform, the respective records will be bounded to the textbox boxes which is on the same form(Main), The problem is clicking on the cells is perfectly working, but when i click the left side column (default) as soon as i click any cells its not working, the respective record will be the bounded to the textbox boxes but the respective selected row from the subform is not highlighting instead of highting the same row . private sub Form_current() Form_frmFundGroup.Filter = "Id = " & Me![Id] Form_frmFundGroup.FilterOn = True end sub the above code is for subform to bound the data as per the selection on the subform(gridvew) how to resolve this can u anyone give me suggestion plz...
kannak