Experts:
I need some assistance with fixing a VBA error after I converted a form's macro (embedded in a form) into VBA.
Attached are two (2) databases "Version 1" and "Version 2".
Information about "Version 1":
- It includes form "F10_StaffMemberDetails" as well as a "Search" macro.
- Upon opening the form, please click on the "Go to" drop-down in the top left of the form.
- The sample data (in table "T01_StaffMembers" contains 3 records); when selecting the combo, the user can select toggle from the current record to either one of the other records.
- This works very nicely!
As I'm making a few changes to this sample form (downloaded from MS-Office), I decided to **convert the form's built-in macro** into VBA (I used the button "Convert Form..." available in the design ribbon).
Now, next is some information about "Version 2":
- Essentially, it is a copy of Version 1 minus the "Search" macro.
- The macro to VBA conversion resulted in plenty of VBA code... at some point, I will have to see what I may no longer need.
Here's what I need some assistance with today. Upon opening the form in Version 2, the "Go to" combo box now results in a **run-time error '35538' (TempVars can only store data. They cannot store objects)**.
How can this VBA (in Version 2) be fixed so that the "Go to" combo works w/o throwing any issues?
Thank you in advance!
EEH