I have tried to set field to "students" after the find but I get a find error.
That really doesn't make sense if you do this after the find. Sounds like you tried to change the field before performing the find.
enter find mode
set field(student name; drop down list field)
set Field [YourTable::Drop down list field ; "Students" ]
should work and should not produce any errors. (Presumably, your drop down list field has global storage as otherwise, your script won't work.
Just a thought, the object is being modified by the set set field to "students" so there for performs the find again as it is set to perform script on object modify. Why not make a button to perform the script placed next to the drop down list.
Set field will not trip the script trigger. One of the Insert script steps that could be used for this, however, would trip the trigger....
Thanks PhilModJunk. I swear I tried that set field on the last step but I believe I used insert text and it wanted to find again.