Hello
New to access, on the job training. I have existing form (Form1, orig. designer is gone), need to search table (Table1) for 'tracking id' which was previously entered (1 ID per person). If 'tracking id' is found, return all table information to the form to be edited/saved (part 2 after finding data - part 1). Have created a 'button' to search using an unbound text field (receiveID) where user will enter the known 'tracking id'. I have tried creating VB embeded macros, external macros, modules, some custom VB search/return code in MS VB screen. Nothing is quite working yet. VB code is not executing, no stub testing done yet. Looking for a correct overall direction.
1. What is the best way to search existing table: embededed/external macros, VB code, etc (runmacro, searchforrecord, etc)
2. Should the an 'embedded/external' macro 'call' another macro, module, VB code?
3. If I am writing VB 'search' code, where should it go/how to 'call'
I found a previous thread, that showed some VB search code (not debugged yet), but not how to execute it.
Thank you
BedfordMA