I need to get a form to open another form and display a specific record. BUT I don't want to apply a filter because the user needs to select any record if they don't want the specific one that is displayed.
I have tried opening the form with a LinkCriteria that selects the records I want (and that works), but if I then remove the filter (forms!formname.filteron=false) the filter is removed but the form jumps to the first record in the database.
The form has an 'OrderBy' on it and I can't take that off because the form sequence would then make no sense to the user.
This is one of those 'this should be simple but I am damned if I can find the answer" questions.