This worked perfectly. However, when I built a new form(LicensingInspectionsListF) based on an aggregate query to view all records from the data in my original form (LicensingInspectionsF) the command button to open a selected record, now defaults to a blank record on LicensingInspectionsF. If I set the data entry property back to Yes on the original form, the selected record opens.  I would very much like to keep the original fix above so any help in resolving this issue, will be wonderful.

---

Reply from Alex Hedley:

Swap it from the On Open method to just a button so you decide when it does it, not every time the form opens.