patrick20001
asked on
how do I unselect a record or clear my selection in datasheet view
I have a form with 3 sub form, all in data sheet view.
When any part of the record is clicked on, the entire record is selected with this:
DoCmd.RunCommand acCmdSelectRecord
Me.Refresh
Once I loose focus on one subform I want to clear the record selection in that subform.
I assume that I should use the subform event "on lost focus" to trigger this event, but I do not know how to unslect the record.
How do I unselect the record?
When any part of the record is clicked on, the entire record is selected with this:
DoCmd.RunCommand acCmdSelectRecord
Me.Refresh
Once I loose focus on one subform I want to clear the record selection in that subform.
I assume that I should use the subform event "on lost focus" to trigger this event, but I do not know how to unslect the record.
How do I unselect the record?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.