Things to keep in mind about Recover:
- Recover does not detect all problems
- Recover doesn't always fix all problems correctly
- Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.
I'd like to see a more detailed descritipion of the steps you took and the design of the layout where you attempted to perform this find. The error message: "[filename] could not be opened" suggests that fileMaker is attempting to open a second filemaker file. This is the file you should recover, not your current file--perhaps that's what you did here, but we need to be sure.