Remove unwanted message (1 Viewer)

kirkm

Registered User.
Local time
Today, 22:53
Joined
Oct 30, 2008
Messages
1,257
My mdb file has 1 table and 2 queries. No code and No Forms.
As if opens (or after Compact Repair) this error message comes up

The form name 'frmRecordSelect' is misspelled or refers to a form that doesn't exist.
lf the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name.


I'm not sure what it means by "Macro Window". Pressing ALT-F11 shows nothing is there.
How might I get rid of this message ?

Thanks
 

Isaac

Lifelong Learner
Local time
Today, 02:53
Joined
Mar 14, 2017
Messages
8,738
Maybe it's in a query. The second portion of that message is boilerplate, I believe, and may not be referencing any actual macro.
 

kirkm

Registered User.
Local time
Today, 22:53
Joined
Oct 30, 2008
Messages
1,257
I've copied the sql from both queries into Word and there's no instance of "Form" or "frmRecordSelect".
I shoudl be able to start a new db and import these 3 componenets, but it'd be good to see what/why this is happening.
 

Isaac

Lifelong Learner
Local time
Today, 02:53
Joined
Mar 14, 2017
Messages
8,738
Also check the File > Options > CurrentDatabase to make sure no start up form that's non existent is specified, also check the Properties pane of the query. Failing that try a new DB.
 

kirkm

Registered User.
Local time
Today, 22:53
Joined
Oct 30, 2008
Messages
1,257
Thanks Isaac, that was it ! frmRecordSelect was the startup form.
 

Users who are viewing this thread

Top Bottom