AKMonkeyboy
IS-IT--Management
I am trying to use a text box (txtLookup) to find information in a calculated field. I say this because I can't use filters on a calculated field.
Access's find feature works fine, but I don't want to have to type in the string to search for (txtLookup is populated from another form and I want to search for that information).
In a nutshell, I'd like to do the following using VBA code:
1)User selects field "txtExtended"
2)User presses "Ctrl-F"
3)User types in information to search for
4)User presses search
5)Access "jumps" to data that matches criteria
I'd like to search "txtExtended" with the value of "txtLookup" as the criteria. Perhaps putting the routine in the double click event of "txtExtended".
Any thoughts?
Access's find feature works fine, but I don't want to have to type in the string to search for (txtLookup is populated from another form and I want to search for that information).
In a nutshell, I'd like to do the following using VBA code:
1)User selects field "txtExtended"
2)User presses "Ctrl-F"
3)User types in information to search for
4)User presses search
5)Access "jumps" to data that matches criteria
I'd like to search "txtExtended" with the value of "txtLookup" as the criteria. Perhaps putting the routine in the double click event of "txtExtended".
Any thoughts?
