I've used the better part of 2 hours searching here and all over the interwebs for a way to create a custom current record box just like the one that comes by default in access. I created 2 text boxes to show my current and total records (not by ID) and I would like to create another box to jump to a specific record of my choosing. I've used a macro that I had for a search box on another access program I made, but cannot make it work. Below are my macros that didn't work. Also, if there's a VBA that would work, I would take it.
1. =[txtCounter2] Like "*" & [Forms]![frmTest3]![txtJumpTo] & "*"
2. =[Form].[CurrentRecord] Like "*" & [Forms]![frmTest3]![txtJumpTo] & "*"
3. =[ID] Like "*" & [Forms]![frmTest3]![txtJumpTo] & "*"
On #1, txtCounter2 is my total records found.
On #2, Form.CurrentRecord is of course my current record. No matter if I delete it, the order will prevail.
On #3, I tried using the ID which is NOT by current record but just wanted to know if I will work...it did not.