Find Record and Maintain List
I have a form with a found set of sorted doors displayed in a list. I want to create a field "Go To Door No." in which users will enter the door number they want and it will find it in the list and and make it the active record. Easy enough if I want only the found door, but I want to maintain the complete list (for the Project currently found). Displaying the previous found set with the door wanted as the active record is where I'm getting stuck.