Hi Ernie,
I suspect that your switchboard is working fine. Something has changed that
is making the form or report request the parameter when you attempt to open
the form or report. Try closing your switchboard form without closing the
database. Then try pressing the F11 key. This will display the database
window, as long as "Use Special Keys" has not been disabled previously. If
you cannot see the database window, then close your database and try
re-opening it while holding down the shift key.
If you now open the same form or report that your switchboard button was set
to open, I suspect that you will see the same parameter requested. If so,
this pretty much rules out any problem in your switchboard.
Have you recently renamed or deleted any fields (for example the MembersID
field in the Members table)? If you can reproduce the error in the form or
report, then the next step is to open this object in design view, and click
on View > Properties, if the properties dialog is not already shown. Click on
the small black square in the upper left corner, in order to select the form.
You should see "Form" displayed in the blue title bar of the properties
dialog. Click on the Data tab. The first entry reads "Record Source". Do you
recognize the recordsource as the name of an existing table or query? If it
is an existing query, or it starts with "SELECT ...", then click into this
entry. When you do, you should see an ellipse button (a button with three
dots). Click this button. It should open the query builder. Try running the
query by clicking on the maroon exclaimation mark. Does the underlying query
run without an error? If not, then you have an issue to fix in the query. If
the query runs fine, but the form or report still presents the error, then
you have an issue to fix in the form or report.
If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
Excuse the Access 2003 n00b here, but I think I may have hosed my switchboard
menu.
I keep getting "Enter Parameter Value" that appears to be referencing
"Members.MembersID" in our membership database. I do not want to be prompted,
I want it to go away. Unless I enter something, it will not access the data.
I can still bring the table up just fine, but somehow (I guess through my
ignorance) something got changed in the form and I don't know hot to get back
to normal.
Any simple (I'm a simpleton) ideas?
