>This error has happened twice and it looks like its happened on 2 different views. These views are opened in the form's environment. How am i supposed to 'wait a few minutes and try again' as suggested by the help file?
Check out the SET REPROCESS command.
Insanity: Doing the same thing over and over and expecting different results.