Dec 23 2021 08:26 AM
After copying my database to another user's laptop (Access Professional Plus 2013) some of the drop lists designed to find a record on the form no longer do so. The combo box at the top of the form continues to work properly on my Windows 11, Office 365 laptop as it did when I had Office 10, Access 2013, etc. I'm wondering if there are administrative actions that might be taken by the equipment owner that would result in the non-functioning combo box.
The combo box/droplist was created with the Access wizard and resulted in a macro that searches for the first record on the form where="[IDperson] = " & Str(Nz([Screen].[ActiveControl],0))
Dec 23 2021 09:31 AM
Let's start with the background to the situation.
These dropdowns have as their recordsource, I assume, production tables such as "customer" or "project' or "sales". You can actually see the records in the combo box, but the code that is supposed to move the form's focus to that record in the table doesn't result in that change.
Does the code even fire on the second laptop? You created a macro, not VBA, which makes it a lot harder to trouble-shoot. You can try stepping through the macro, though, to see if you can identify something useful.
On the second laptop, is Trusted Locations enabled for the folder where the accdb is located? If not, got to the Trust Center and indicate where the accdb is as a Trusted Location.
Dec 23 2021 02:01 PM
Dec 23 2021 03:38 PM
Yes, you can convert macros to VBA, although it's quite rudimentary.
You can then step through the VBA to see what is happening at each step of the code.
Dec 23 2021 09:48 PM
Dec 24 2021 01:16 PM
Dec 24 2021 01:22 PM