I have a database with a bunch of data entry forms that are used for entering and editing records.
What I want to do is use the form to also search for specific records.
Specifically, I have a text box bound to an ID value (not the primary key, just a unique string), call it tbxID.
What I want is a before update event procedure that will look up the record that matches tbxID.text.
This procedure should not modify the record that was current when the search was started.
I'm pretty sure that I can do this in VB but I wonder if there isn't a simpler way to do it with a macro.
What I want to do is use the form to also search for specific records.
Specifically, I have a text box bound to an ID value (not the primary key, just a unique string), call it tbxID.
What I want is a before update event procedure that will look up the record that matches tbxID.text.
This procedure should not modify the record that was current when the search was started.
I'm pretty sure that I can do this in VB but I wonder if there isn't a simpler way to do it with a macro.