Thank you everyone for all of your suggestions and responses. However none seem to work.
HA! The error sounds good. Is there a button on it called debug or similar? If so, hit it and see where you land.
Unfortunately there was no debug button just "OK" and "Help", which says: "This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.".
In experimenting I deleted the ClientIDTxt field to see if that would help. It didn't so I re-created it. Now the error message doesn't appear but the request for parameters still does.
Download V-tools and use the Total Deep Search with the term that is appearing in the parameter dialog. It will show every reference to that term in the parts of the project you select in the configuration.
I downloaded every version of the V-tools for 2007 and none of them could be opened. It keeps saying "The database is in an unrecognized format... may have been created with a later version...etc." I downloaded them from
http://www.skrol29.com/us/vtools.php#download. Is that the correct site?
Your problem looks to be this in the SQL of the query:
PARAMETERS [Forms]![ZooMobile Event Booking].[ClientIDTxt] Text ( 255 );
remove the Parameter from the query parameters dialog or just delete that line from the SQL View of the query.
The query has been deleted and I haven't created another one yet. Where can that SQL be hiding? Or should I try re-creating it? I'm worried that this will complicate the issue, especially since I can't remember the exact coding that I used.
This also often occurs when the form is still trying to order or filter the dataset on that specific removed field. Remove these references in the properties of the form.
That's what I've been trying to do but I have no idea where those references could possibly be. I've looked through all of the fields in the forms (of course I may have missed a few so I'll try again).
I know that I'm being a real pain but could someone please use the copy that I uploaded and try your suggestions on it? Perhaps I am doing them wrong, and without seeing it in person I'm having a hard time ensuring that I'm doing what you are all suggesting correctly.