Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

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

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?
1 Solution
Gustav BrockCIOCommented:
You could create a tiny textbox, txtHideFocus, which must be enabled and visible.
Then set focus to this as you leave the subform.


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now